Michael Dean
asked on
VBA Issue with Access
Everytime I try and compile the code in my access 2007 data base I get an error that states
"error accessing file connection may be lost"
"error accessing file connection may be lost"
ASKER
That states access 2000. I'm using 2007
Are you using a split database setup? If so can you verify that the tables are linked correctly?
Try importing all objects to a new database.
Try importing all objects to a new database.
ASKER
yes I am using a split database and have relinked all the Tables again from the backend.
And the error still occurs?
Did you try importing all objects to a new database?
Did you try importing all objects to a new database?
ASKER
so when you say all the objects, do you mean import all the forms, queries, macros ect.. into a new FE?
ASKER
when I try to import all the objects into a new database I get the same error while its importing
error accessing file connection may be lost
error accessing file connection may be lost
Before doing anything else, make a backup of your database.
Are you able to Compact the database? In 2007 you click the big Office button, then click Manage - Compact.
If you can't do that, try Decompiling the database. To do that, create a shortcut with this as the Target:
"full path to msaccess.exe" "full path to your database" /decompile
If you can successfully decompile, then try the Compact again. If you can compact, I'd still import everything into a new container.
Also be sure that your Office and Windows installations are fully up to date. Issues like this can often be caused by faulty/corrupt installations.
Are you able to Compact the database? In 2007 you click the big Office button, then click Manage - Compact.
If you can't do that, try Decompiling the database. To do that, create a shortcut with this as the Target:
"full path to msaccess.exe" "full path to your database" /decompile
If you can successfully decompile, then try the Compact again. If you can compact, I'd still import everything into a new container.
Also be sure that your Office and Windows installations are fully up to date. Issues like this can often be caused by faulty/corrupt installations.
ASKER
So I did all that. Does the decomplile remove all the Code? And then do I have to import the modules back into the FE DB?
ASKER
cant seem to figure this out. I have attached the FE and BE version of the database, if someone could look into this and figure out what is wrong with the VBA projects I would much appreciate it.
There is no confidential information in this database.
LARMSV-FE-v2.0--2-.accdb
LARMSV-BE-V2.0.accdb
There is no confidential information in this database.
LARMSV-FE-v2.0--2-.accdb
LARMSV-BE-V2.0.accdb
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
so what is my option???
Use a backup if you have one.
There are some services that will attempt to fix a corrupt database. The best one seems to be www.everythingaccess.com.
http://support.microsoft.com/kb/304548