473,568 Members | 2,999 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Database cannot be opened because the VBA project contained in it cannot be read.

23 New Member
I have a split database on our network and lately (the past several weeks), it's been seemingly-randomly giving this error to users:
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. and then it talks about making a backup.

The only way to get past the error is to click OK (cancel doesn't do anything), and then it opens the database without any code (so it's useless).

I've Googled this problem many times and came across this: http://support.microso ft.com/kb/2533794
I've decompiled, as it recommends, and then it works for another day or two before it breaks again and gives the same error. I've also decompiled, compact & repair, recompiled... tried various forms of that - but nothing works for very long.

Does anyone know of a long-term solution to this problem?

Thanks!!
Feb 13 '12 #1
11 18109
Seth Schrock
2,965 Recognized Expert Specialist
I have had similar weird problems with Access 2010 (I'm not sure which version you are using). Sometimes I have been successful with just copying and pasting all the queries, forms, reports, etc. into another brand new database file.

If that doesn't work, then try copying one object at a time over till you find which object is causing the problem and then redo it from scratch.

Also, where is your front end stored?
Feb 13 '12 #2
NeoPa
32,564 Recognized Expert Moderator MVP
Have you upgraded all your Access installs on all the PCs to the latest Service Pack. That's my reading of the linked article. Until this is finished these errors are likely to reccur.
Feb 14 '12 #3
Katie Howard
23 New Member
I'm running Access 2010, SP1. Our entire company was upgraded to this a couple months ago - which, ironically, is about the same time we started getting these errors (I was previously on Access 2007).

Both the back end and the front end are on our network. We have over 5,000 employees who need access to this database, so it just didn't make sense to try to get everyone to put the front end on their local computers.

I guess I'll have to try copying everything over into a new database, if you really think that will help. I hesitate because I have about 100 queries and another 30 or so forms and reports, and then some tables that are linked to the back end and other tables that are linked to a SQL database.

Thanks for your help.
Feb 14 '12 #4
NeoPa
32,564 Recognized Expert Moderator MVP
What I understand from the article is that if the database is ever opened on any of the PCs where Access has not been upgraded to 2010 SP1 then this issue is likely to occur. I don't believe that the database itself needs changing necessarily (I see nothing to indicate that at least), and I can clearly see why upgrading 5,000 PCs at a time could be complicated, but I would at least consider blocking those PCs which are not yet upgraded from accessing that version of the database. Another version for those PCs may be in order until the full migration has been completed, but it seems mixing the old with the new on the same database is not a good mix.
Feb 14 '12 #5
brianwatson
1 New Member
Only compile the application on the server and not a stand alone PC. Different PC's can contain different attributes, due to this central compiling is essential.
Aug 6 '12 #6
zmbd
5,501 Recognized Expert Moderator Expert
Do I understand this correctly:
You have 5000 users opening the same front-end file?
Or
Are each of the users downloading a copy of the front-end file to their local PC and running it from there?
-Z
Aug 6 '12 #7
twinnyfo
3,653 Recognized Expert Moderator Specialist
Katie,

Also, there is a way to install the FE to everyone's PC, and whenever there are changes, those updates are copied down to the local machine. If you get this error corrected, you may want to explore that option, as well, so that you don't have to worry about kicking 5,000 people out of the DB every time there is an update......
Aug 6 '12 #8
zmbd
5,501 Recognized Expert Moderator Expert
One method would be to use a batch file that copies from a central store to the local pc: i.e. I have a "production " copy of the front-end located on the server. In that same folder is the batch file that deletes the current copy in the users profile and then copies the current version to the local drive. Once done, the batch file then launches the Access application. I then send a short-cut to each user, the short-cut points to the batch file.

I have also taken a look a some things that launch a Script shell and a batch file based in local version versis networked version that I may start using when I complete a current project; however, I havn't vetted them yet.

-z
Aug 6 '12 #9
Katie Howard
23 New Member
5,000 users (actually, now we're at about 5,800) have access to the same front end - but the vast majority don't use it; they just have to be able to open the file should there ever be a need for it.
I know that ideally we'd have the front end on each of their local machines, but I don't see that as realistic in this case, unfortunately.

I did create a 2nd front-end that our 3 heaviest users access, and that's significantly cut down on the frequency of these errors. It used to happen about 1-3 times a week, and since I created that 2nd front end, it only happens about 1 or 2 times a month.
Aug 7 '12 #10

Sign in to post your reply or Sign up for a free account.

Similar topics

0
1095
by: Ezhiha | last post by:
I've WinXP + IIS 5.1. The server works without any problem, i.e., when I trying http://localhost/index.asp it executes the script index.asp. But when I create a new prokject in .NET it gives the next error: The default Web access mode for this project is set to file share, but the project folder at 'http://localhost/WebApplication1' cannot...
1
3485
by: David | last post by:
I am working on a small web app. I attempted to copy it to the remote server via. the project/copy command and when I closed the project and attempted to reopen it, I get the error "project file cannot be found". The system also tells me that some of the components are not installed on the web server. However, I have the IIS installed and...
1
1513
by: Jack G | last post by:
I've been trying to create a new web application project in Visual Studio 2003 running on a Windows Server 2003. I get the message Window titled Web Access Failed The default Web access mode for this project is set to file share, but the project folder at http://localhost/NewWebPage cannot be opened witht he path 'G:\Zoning\NewWebPage' the...
3
2327
by: DC Gringo | last post by:
Hi, I'm trying to use a custom action to modify a database (rather than create one) using the VS.NET '03's help example called "Custom Action to Create Database During Installation". I've made two modifications to the sample in the document...both are in the "Protected Sub AddDBTable" (towards the bottom). I've changed ' Creates the...
0
949
by: t b | last post by:
I get an error msg that says "Cannot create project" and and "Error setting document properties" when I try to create an Excel project using VSTO...but it does not happen w/MS Word from within VS 2005 .net. *** Sent via Developersdex http://www.developersdex.com ***
0
2022
by: thjwong | last post by:
I'm using WinXP with Microsoft Visual C++ .NET 69462-006-3405781-18776, Microsoft Development Environment 2003 Version 7.1.3088, Microsoft .NET Framework 1.1 Version 1.1.4322 SP1 Most developers said to me that they have no problem doing that, but the following project file is said to be corrupted while opening in the IDE, it is the project...
2
3253
by: keri | last post by:
Please help. I have a database I built but have not used for ages. When I have come to make some changes today in VBA I get the error cannot find project or library I have references to Visual basic for applications Access 9.0 object library OLE automation DAO 3.6 object library
1
1564
Mohan Krishna
by: Mohan Krishna | last post by:
Hi everyone, I am doing a project in VB with Access or SQL as backend. Please help me whether we can Add or Delete a Column in backend database in VB project dynamically (i.e. while running the project) by the client? Also give me the possible code for both MS Access and SQL to do so. Thank you all in advance!
2
1561
by: bobh | last post by:
Hi All, Anyone have code to share that would detect if a database was opened to database window view??? and since holding the 'you know which key' down, no form is loaded, the autoexec marco does not run so, where would one put such code that it would run? thanks bobh.
5
10544
stonward
by: stonward | last post by:
Hi Folks, This one is from work! Running Access 07, usually our default saving format is 2003 - not our fault. I want to publish a database to our SharePoint system, but the database must be in an 07 format, and I can't save new databases without getting the (above) message. I have tried taking permission of the file, creating a new...
0
7690
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7597
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
7909
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
0
8115
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
1
7654
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
6273
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
0
3649
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
1
2093
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
0
930
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.