Solved

VBA Issue with Access

Posted on 2014-03-02
14
290 Views
Last Modified: 2014-03-04
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"
0
Comment
Question by:seamus9909
  • 7
  • 5
  • 2
14 Comments
 
LVL 26

Expert Comment

by:MacroShadow
Comment Utility
0
 

Author Comment

by:seamus9909
Comment Utility
That states access 2000.  I'm using 2007
0
 
LVL 26

Expert Comment

by:MacroShadow
Comment Utility
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.
0
 

Author Comment

by:seamus9909
Comment Utility
yes I am using a split database and have relinked all the Tables again from the backend.
0
 
LVL 26

Expert Comment

by:MacroShadow
Comment Utility
And the error still occurs?

Did you try importing all objects to a new database?
0
 

Author Comment

by:seamus9909
Comment Utility
so when you say all the objects, do you mean import all the forms, queries, macros ect.. into a new FE?
0
 

Author Comment

by:seamus9909
Comment Utility
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
0
Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
LVL 84
Comment Utility
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.
0
 

Author Comment

by:seamus9909
Comment Utility
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?
0
 

Author Comment

by:seamus9909
Comment Utility
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
0
 
LVL 26

Accepted Solution

by:
MacroShadow earned 500 total points
Comment Utility
Seems corrupt beyond repair.
0
 

Author Comment

by:seamus9909
Comment Utility
so what is my option???
0
 
LVL 26

Expert Comment

by:MacroShadow
Comment Utility
Use a backup if you have one.
0
 
LVL 84
Comment Utility
There are some services that will attempt to fix a corrupt database. The best one seems to be www.everythingaccess.com.
0

Featured Post

Get up to 2TB FREE CLOUD per backup license!

An exclusive Black Friday offer just for Expert Exchange audience! Buy any of our top-rated backup solutions & get up to 2TB free cloud per system! Perform local & cloud backup in the same step, and restore instantly—anytime, anywhere. Grab this deal now before it disappears!

Join & Write a Comment

It took me quite some time to sort out all the different properties of combo and list boxes available from Visual Basic at run-time. Not that the documentation is lacking: the help pages are quite thorough and well written. The problem was rather wh…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now