 | | | Microsoft access table refresh | Microsoft access table refresh 2006-10-06 - By Huhncke, David M.
Back
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)
|
|
|