MySQL be problems

[groengoen]

I have recently tried to create a MySQL back end to my Access database. In one table, when I look at the key in the MySQL admin, I see that it is type bigint(20) and when I look at it in the design view in Access the same field shows up as type Text size 255. I am not allowed to correct a linked table, and I do want the field to be numeric, as on the MySQL table. I have tried using the Linked Table Manager to refresh this table but that doesn't work.

When I use an Access form to view this table all the fields have "#Name?" in them. I suppose this is because of the problem with the key.

How can I correct this problem?

Geoff

 

[RainLover]

If you converted an Access BE to MySQL you will find that some Types do not convert properly.

I believe you need INT for Autonumber in MySQL. You need to fix these then in Access delete all tables and relink.

 

[groengoen]

Great! Thanks a million for your prompt response. That worked for that particular table. I will have to go through the other 50 tables. Groan!

Geoff

 

[RainLover]

Amazing.

It has been years since I used MySQL. Got to get lucky sometimes.