?
Solved

VBA Issue with Access

Posted on 2014-03-02
14
Medium Priority
?
303 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 7
  • 5
  • 2
14 Comments
 
LVL 27

Expert Comment

by:MacroShadow
ID: 39898842
0
 

Author Comment

by:seamus9909
ID: 39898846
That states access 2000.  I'm using 2007
0
 
LVL 27

Expert Comment

by:MacroShadow
ID: 39898866
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
What Is Blockchain Technology?

Blockchain is a technology that underpins the success of Bitcoin and other digital currencies, but it has uses far beyond finance. Learn how blockchain works and why it is proving disruptive to other areas of IT.

 

Author Comment

by:seamus9909
ID: 39898873
yes I am using a split database and have relinked all the Tables again from the backend.
0
 
LVL 27

Expert Comment

by:MacroShadow
ID: 39898886
And the error still occurs?

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

Author Comment

by:seamus9909
ID: 39898895
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
ID: 39898907
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
 
LVL 85
ID: 39899078
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
ID: 39899120
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
ID: 39899168
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 27

Accepted Solution

by:
MacroShadow earned 2000 total points
ID: 39899305
Seems corrupt beyond repair.
0
 

Author Comment

by:seamus9909
ID: 39899421
so what is my option???
0
 
LVL 27

Expert Comment

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

Featured Post

What Is Blockchain Technology?

Blockchain is a technology that underpins the success of Bitcoin and other digital currencies, but it has uses far beyond finance. Learn how blockchain works and why it is proving disruptive to other areas of IT.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
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…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
Suggested Courses

801 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