Error: 457 (0x1C9)

General usage of Access to MySQL

Moderator: jr

Post Reply
francisco.almeida
Posts: 2
Joined: Wed Jun 06, 2007 12:54 pm
Location: St. Albans - UK

Error: 457 (0x1C9)

Post by francisco.almeida »

Hi Mates,

I've got an error when the program tried to show the tables.
Does anyone know how to fix it? or what does it mean?

Thanks,

Francisco

---------------------------
MS Access to MySQL
---------------------------
Error in function 'cmdNext_Click'

Error: 457 (0x1C9)

Reason: This key is already associated with an element of this collection

Debug information: Initializing



Version: 2.0.57
jr
Site Admin
Posts: 500
Joined: Sun Mar 26, 2006 12:28 pm

Post by jr »

Hi Francisco,

You can zip your database and send it to info*at*bullzip.com. Then I can reproduce the problem and fix it. If your database contains confidential information then you can delete the data in the tables and give me the empty tables. I think it is related to the database schema.

Regards,
Jacob
francisco.almeida
Posts: 2
Joined: Wed Jun 06, 2007 12:54 pm
Location: St. Albans - UK

Post by francisco.almeida »

Hi Jacob,

I've found what was the problem. It was regarding with a query that I had in my DB. I've deleted and It is now working properly.

By the way, the tool is very good.

Many thanks,

Francisco
Post Reply