|It is sometimes a good idea to decompile your database and then compacting and repairing. I had a similar issue just the other week, my database kept of throwing an error "File not found" however i have no code within my DB that searching or references ANY file. I just decompiled the code and it all worked again..|
Create a shortcut and enter the below into the taget, you can also copy paste a shortcut and edit the target to the below. You will need the path to where MS ACCESS is installed and the path to where you database is stored.
Then run the shortcut and it should decompile your database. Once you've sucessfully done that, compact and repair it again.
"C:\Program Files\Microsoft Office\Office14\MSACCESS.EXE" "c:\YourDatabaseName.mdb" /decompile
message edited by AlwaysWillingToLearn