Microsoft access table refresh

"Huhncke, David M." <[email protected]>
Newsgroups gmane.comp.db.mysql.odbc
Message-ID <[email protected]>
Microsofts latest release of msjet40.dll (version 4.0.9025) which is
included in Windows server 2003 SP1 causes msaccess to crash when
performing a table refresh/relink to mysql tables using MyODBC 3.51.12.
This has been confirmed using a windows 2003 server without SP1
msjet40.dll (version 4.0.86180) msaccess relinks mysql tables
successfully.    This is a big problem and causes us great concern,
since it appears Microsoft again is tweaking their software to force us
down the sql server  path.   I have put a call into Microsoft and asked
them for a work-around or fix since removing SP1 would only be a
temporary fix.   I would also like to know if Mysql can tweak their ODBC
driver or find out what MS has done to cause this problem and fix it.

Here is VB that relinks Mysql tables and works using msjet40.dll
(version 4.0.86180) but fails with (version 4.0.9025) 

Sub Link_Refresh()
Dim strUserID As String, strPassword As String, dbname As String
strUserID = "chronoCon"
strPassword = "chronoCon"
dbname = "CHRON20_D"
str1 = "DRIVER={MySQL ODBC 3.51
Driver};SERVER=docr1929.doc.nd.gov;DATABASE=" & dbname & ";USER=" _
       & strUserID & ";PASSWORD=" & strPassword & ";OPTION=35;"

 
  Dim curDb As Database
  Dim tdfLinked As TableDef

  ' Create a reference to the linked table
  Set curDb = CurrentDb
  Set tdfLinked = curDb.TableDefs("Tbl_Contacts")
  
  ' relink the table connection to Mysql
  tdfLinked.Connect = str1
  tdfLinked.RefreshLink

End Sub
Thank you. 

David Huhncke
Director Information Systems
ND Dept. Of Corrections & Rehabilitation
701 328-6361
701 527-0234 (cell)
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.