Answer for:

Using MS Access and ODBC to access an SQL Database

Message 8 of 13

View entire thread
0 Votes

As far as I have experienced. I am no database expert, but I have written a lot of systems here which use Access front end, some with an Access back end, some with SQL Server 2000.

I haven't suffered the same exact problem, but I have had problems when changing the back end from one to another. My resolution was to decompile the Access front end, then compact and repair, save it,exit, then recompile and correct errors as found.

From the command prompt, or a batch file, run

"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" "path_to_your_file\your_access_db.mdb" /decompile