Solved

VBA Issue with Access

Posted on 2014-03-02
14
298 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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

740 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