Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2005

    Unanswered: Access Losing Links to MySQL

    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.

    Exact error message is: ODBC -- Connection to "GreenSheet" failed

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

  2. #2
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    it doesn't solve why access is disconnecting from MySQL (perhaps because you are committing the crime of not using a Micorsoft back end), but as a work around you could programaticaly check if the tables are linked, and if not relink through code prior to using the tables for any other purpose.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts