Recent content by frank4401

Eureka! Original line: tdf.Connect = "ODBC;DATABASE=" & MySQLdb & ";UID=SA;PWD=;DSN=" & MyDSN Working line: same as above but with: "DRIVER={SQL Server};SERVER=JSE2005;" I guess MS Access 2007 needs the DRIVER and SERVER clauses for whatever reason. ttfn

I've tried various references but no luck. Microsoft wants $259 just to talk to me. Should I pay?

I have DAO 3.6 OL referenced but still no luck

Trying to reprogram my Msaccess 2000 to 2007, time to update. Using MSSQL 2000 data tables. When the programs start, I can push a button that allows me to re-connect to either the Real Data or Test Data. A simplified version of the code is as follows: Public Function ReAttachBuildersTable() As...