Query wont allow additions in MySQL

[303factory]

Hi

I've recently linked my Access front end to a MySQL back end.

It's more or less running ok, but some quieries wont allow new rows, ie no blank row appears at the bottom for you to type new data in. You can do this directly to the table, but not a quiery based on the table of subform linked to that query.

Any idea why? It's strange because I recreated two tables from scratch, one allows additions through query but the other doesnt.. so I'm presuming it is something to do with the query itself?

Regards

303

 

[Banana]

If it's based on a query: See if this helps.

If you're still stumped, post the SQL here and maybe we can identify what's wrong with it.

Are you able to update each of all tables involved in the query? Or did you say one table doesn't allow updating at all?

 

[303factory]

If it's based on a query: See if this helps.

If you're still stumped, post the SQL here and maybe we can identify what's wrong with it.

Are you able to update each of all tables involved in the query? Or did you say one table doesn't allow updating at all?

Problem solved! It's because my queries didnt include the ID primary key which my access tables didnt have but I had to create for my MySQL version.

Thanks for your help

 

[Banana]

Great. Glad you figured out the cause.

As a general reference, I usually refer Jet & ODBC Connectivity whitepaper which contain useful information on using Jet effectively to communicate with ODBC backend (including MySQL) and some common troubleshooting. You can find it at support.microsoft.com and downloading.


Best of luck!