Re: Unstable links to MySQL database from Access

[Jim Hanley]

After some testing, if I manually refresh the links, then close the database (but do not exit Access ) then re-open the mdb file, it continues to work without the need to refresh the MySQL tables...

I also checked the value of all the properties to the tables before and after the refresh, and other then the dateCreated/Updated there is no change... not really sure what that means, but I thought it might be useful in finding out why the driver does this.

Here's a snippit of my debug info... at 8:58 is when I tried to run without refreshing, the 9:02 is after refreshing...

--------------------------------------------------------------------------------
01-17-2005 08:58:41: Initialize Log Class
01-17-2005 08:58:41: tbl.name = [ttmp_customers]
01-17-2005 08:58:41: tbl.Attributes = [536870912]
01-17-2005 08:58:45: tbl.ConflictTable = []
01-17-2005 08:58:45: tbl.Connect = [ODBC;DATABASE=TTMP_Lics;DESCRIPTION=TTMP_Lics;DRIVER=MySQL ODBC 3.51 Driver;DSN=TTMP_lics;SERVER=soy.lalalala.com;]
01-17-2005 08:58:45: tbl.DateCreated = [1/17/2005 8:50:29 AM]
01-17-2005 08:59:00: tbl.LastUpdated = [1/17/2005 8:50:29 AM]
01-17-2005 08:59:00: tbl.RecordCount = [-1]
01-17-2005 08:59:04: tbl.ReplicaFilter = []
01-17-2005 08:59:04: tbl.SourceTableName = [ttmp_customers]
01-17-2005 08:59:04: tbl.Updatable = [False]
01-17-2005 08:59:04: tbl.ValidationRule = []
01-17-2005 08:59:04: tbl.ValidationText = []
--------------------------------------------------------------------------------
01-17-2005 09:02:41: Initialize Log Class
01-17-2005 09:02:41: tbl.name = [ttmp_customers]
01-17-2005 09:02:41: tbl.Attributes = [536870912]
01-17-2005 09:02:45: tbl.ConflictTable = []
01-17-2005 09:02:45: tbl.Connect = [ODBC;DATABASE=TTMP_Lics;DESCRIPTION=TTMP_Lics;DRIVER=MySQL ODBC 3.51 Driver;DSN=TTMP_lics;SERVER=soy.lalalala.com;]
01-17-2005 09:02:45: tbl.DateCreated = [1/17/2005 9:01:46 AM]
01-17-2005 09:02:45: tbl.LastUpdated = [1/17/2005 9:01:47 AM]
01-17-2005 09:02:45: tbl.RecordCount = [-1]
01-17-2005 09:02:49: tbl.ReplicaFilter = []
01-17-2005 09:02:49: tbl.SourceTableName = [ttmp_customers]
01-17-2005 09:02:49: tbl.Updatable = [False]
01-17-2005 09:02:49: tbl.ValidationRule = []
01-17-2005 09:02:49: tbl.ValidationText = []

Is there anything else I could/should check?