MySQL Forums
Forum List  »  Microsoft Access

Re: Unstable links to MySQL database from Access
Posted by: Jim Hanley
Date: January 17, 2005 08:14AM

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?

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.