Solved

VBA Issue with Access

Posted on 2014-03-02
14
296 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 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
Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

 

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 84
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 500 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 84
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

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

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

The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
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…

813 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

11 Experts available now in Live!

Get 1:1 Help Now