473,698 Members | 2,306 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 18131
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,569 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,569 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
1101
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 be opened with the path 'c:\inetpub\wwwroot\WebApplication1'. The error returned was: Unable to...
1
3491
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 I can create a new web app and it works fine. How can I find what is missing? I hate to loose a...
1
1525
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 error returned was: Unable to create Web project 'NewWebPage'. The file path...
3
2334
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 database.
0
954
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
2028
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 file of NT xemacs BETA 21.5.24, http://ftp.xemacs.org/pub/beta/xemacs-21.5.24.tar.gz (under the...
2
3256
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
1567
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
1565
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
10546
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 database and transferring the data across and changing the default format. Nothing works. Once I have made...
0
8598
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 synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9152
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. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
9014
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 captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
8885
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 most users, this new feature is actually very convenient. If you want to control the update process,...
0
8855
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
4358
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 the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4612
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
2320
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
1995
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 effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.