Solved

The database cannot be opened because the VBA project contained in it cannot be read

Posted on 2013-06-30
6
1,087 Views
Last Modified: 2013-07-02
I have an accde installed on clients machines in a run time environment.  On one machine, I get the following error message:

The database cannot be opened because the VBA project contained in it cannot be read. The database can be opened only if the VBA project is first deleted. Deleting the VBA project removes all code from the modules, forms and reports. You should back up your database before attempting to open the database and delete the VBA project.

Can anybody help?

Thanks in advance.
0
Comment
Question by:CRB1609
[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
6 Comments
 
LVL 27

Assisted Solution

by:MacroShadow
MacroShadow earned 100 total points
ID: 39289102
It sounds like the file is corrupted. Back-up the tables if you can, (import the tables from a new file) then replace the accde with a working version and import the tables.
0
 
LVL 77

Expert Comment

by:peter57r
ID: 39289240
And if you are not using a split database, now is the time to change it so that you are.
0
 

Author Comment

by:CRB1609
ID: 39289291
Yes, I'm using a split database and it's already installed in about 100 sites, so I'm assuming that we are talking about the front end.  I'll rebuild the  latest release of the app and see if that fixes it.
0
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 
LVL 77

Accepted Solution

by:
peter57r earned 400 total points
ID: 39289332
If it was corruption of the front-end you should only have  to copy a new front-end and that should be that.
0
 
LVL 21
ID: 39290172
I assume that you have the front end copied to each user's local hard drive or none shared folder..

I agree that you need to replace the front end for the user having issues.

I use an app launcher that automatically copies a new front end eery week to avoid this issue.

Free example: Application Starter
0
 

Author Closing Comment

by:CRB1609
ID: 39294981
Thank you very much.
0

Featured Post

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

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

Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

728 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