General discussion

Locked

Access losing links

By sfreincle ·
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.

This conversation is currently closed to new comments.

6 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by BFilmFan In reply to Access losing links

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.

Collapse -

by sfreincle In reply to

Poster rated this answer.

Collapse -

by sfreincle In reply to Access losing links

Permissions is not an issue. We now have a module that relinks the tables at startup.

Collapse -

by sgt_shultz In reply to Access losing links

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...

Collapse -

by sfreincle In reply to

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.

Collapse -

by sfreincle In reply to Access losing links

This question was closed by the author

Back to Software Forum
6 total posts (Page 1 of 1)  

Related Discussions

Related Forums