View Single Post
  #10 (permalink)  
Old July 23rd, 2008, 12:16 AM
gadgetguy gadgetguy is offline
Registered User
Join Date: Apr 2008
Location: , , .
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts


This error mcome when you link tables via mapped drive user UNC instead or lost network connection. It is quite possible that every time the database is opened, the startup deletes current links and creates new links to tables in a file path set in an ini file. to avoid this error Set dbs = Workspace.OpenDatabase (”C:\Temp\Database.mdb”)

Check for the path and file must be valid for a statement using the CurrentDB method to function properly or you can try to delete link table. It is also possible to change or examine the connect property of a table. If still get error that means your database is corrupt and you have to repair it. Repair it use of compact and repair utility or you can try access repair software to repair your damaged database so that you can use it as before.