Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1369
  • Last Modified:

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

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
Clive Beaton
Asked:
Clive Beaton
2 Solutions
 
MacroShadowCommented:
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
 
peter57rCommented:
And if you are not using a split database, now is the time to change it so that you are.
0
 
Clive BeatonAccess DeveloperAuthor Commented:
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
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

 
peter57rCommented:
If it was corruption of the front-end you should only have  to copy a new front-end and that should be that.
0
 
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPCommented:
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
 
Clive BeatonAccess DeveloperAuthor Commented:
Thank you very much.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now