Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

VBA Issue with Access

Posted on 2014-03-02
14
Medium Priority
?
306 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
NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

 

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

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

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

AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

610 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