Discussion Locked

Access losing links

0 helpful
6 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have an Access application with links to MySQL tables. Every time I start the application I get error messages indicating inability to read the linked tables. When I have relinked everything works fine, but eventually I log off the application and get the same problem the next time I open the application.

A similar question was posted in April 2004, but no solution that worked was posted. Exact error message is: ODBC -- Connection to "GreenSheet" failed

When I defined this connection using ODBC Datasource Administrator, the test works fine.

6 replies

by bfilmfan

Check the permissions on the tables you are trying to read. Since you have an account for which it does work, I'd match the rights for that account. Then slowly remove rights until it stops working. As I recall, most Access applications writing to tables needed at least "Editor" level permissions.

by sgt_shultz

maybe he sql engine is not fully up or something. have you tried that for a test. start the app, see the error. relink. see it go away. go to services stop sql client engine. see problem reappear.-? i think i may have read something about this in the mskb. do you have anything in the event logs. if service is set to manual, will setting it to automatic fix it i wonder...

by sfreincle

I ended up writing code that links the Access front-end to MySQL directly, without using a dsn. This is working ok. I'll check your solution as soon as I get a chance, though. Thanks.

This discussion is closed to new replies.