VBA Issue with Access

seamus9909
seamus9909 used Ask the Experts™
on
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"
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Author

Commented:
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.
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Author

Commented:
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?

Author

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

Author

Commented:
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
Most Valuable Expert 2012
Top Expert 2014

Commented:
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.

Author

Commented:
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?

Author

Commented:
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
Seems corrupt beyond repair.

Author

Commented:
so what is my option???
Use a backup if you have one.
Most Valuable Expert 2012
Top Expert 2014

Commented:
There are some services that will attempt to fix a corrupt database. The best one seems to be www.everythingaccess.com.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial