VBA Issue with Access

Microbug...

http://support.microsoft.com/kb/304548

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.

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?

so when you say all the objects, do you mean import all the forms, queries, macros ect.. into a new FE?

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

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.

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?

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

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.