473,749 Members | 2,356 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Error in Access 2007 Corrupt VBA project

7 New Member
I designed a db in Access 07 and opened it up once in Access 2003. No when I open it up in 07 again I get this 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 modules,
forms and reports"

Is there any way to extract the vba code and modules from the corrupt db? I would really hate to have to rewrite ALL the code over again. If I can get the modules and codes out maybe I can fix what might be wrong.
Feb 21 '08 #1
2 4042
mshmyob
904 Recognized Expert Contributor
Access 2003 cannot read an Access 2007 file - it has a new extension of .aacdb.

I assume you created it in Access 2007 but saved it in the 2003 format.

I designed a db in Access 07 and opened it up once in Access 2003. No when I open it up in 07 again I get this 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 modules,
forms and reports"

Is there any way to extract the vba code and modules from the corrupt db? I would really hate to have to rewrite ALL the code over again. If I can get the modules and codes out maybe I can fix what might be wrong.
Feb 21 '08 #2
Megalog
378 Recognized Expert Contributor
Did you try starting a new db in Access 2007, and then importing what you can from the corrupt copy via 'External Data' > 'Import' > 'Access' ?

Or if that doesnt work.. then maybe open it up again with an Access 2003 copy, and then copy out the code into notepad or something....
Feb 21 '08 #3

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

Similar topics

1
6806
by: ishwarjoshi | last post by:
I am in the process of upgrading an old Access ADP/SQL 2000 App to Access 2007 ADP/SQL 2005. There are a lot of buttons in the Access form which are calling Access Macros, the Macros call Stored Procedures in the SQL database. This is resulting in '2950 Error' for all the macros. Here is Microsoft' answer for that error: http://support.microsoft.com/kb/931407 *edit*
2
3790
by: ARC | last post by:
Just curious if anyone is having issues with Acc 2007 once the number of objects and complexity increases? I have a fairly large app, with many linked tables, 100's of forms, queries, reports, and lots of vba code. I'm nearly finished with re-doing my app in access 2007, and just imported an add-in program, which has added even more forms, queries and linked tables. Every so often now, after opening many different screens, I'll...
1
4467
by: MsfStl | last post by:
I appear to have some sort of corrupt object in my Access 2007 db. Anytime, I leave a Design view of a form the db crashes. It then tries to send MS an error message and then compact and repair itself, to no avail. Any thoughts? Thanks.
2
1666
by: anthony | last post by:
I have an old database which started out life in the Access 2 days! It's full of lots of stuff which I'm not convinced is relevant any longer. Would a good way forward be to create a new, blank database in Access 2007 and then import the existing objects, re-create the relationships etc? That way I can just bring in the stuff that's currently in use and, hopefully, have a better chance of avoiding database corruption. The alternative, I...
3
4877
by: anthony | last post by:
I've been busy converting an existing 2003 database into 2007 by dint of creating a new accdb database and importing the objects into it. Everything went smoothly and all the objects imported without a problem. I then ran a compile, discovered a problem with wdOpenFormatAuto not being recognised so added a couple of libraries. I also added two locations to the Trust Centre. Whether related or not, when I now try to open the database I get...
1
7075
by: myipmike | last post by:
Hi there, I have an app that produces labels and which runs fine under Access 2000, 2002 and 2003. The compiled 2002 .mde version runs fine under Access 2007 but only sometimes ! i.e. under XP with Access 2007 no SP it's fine but under XP with Access 2007 SP1 I get #name? in the label fields same deal if under Vista with 2007 no SP, and Vista with SP1
4
2547
by: Milan Mehta | last post by:
I am new to Access. I have developed an application in Access 2007. I have kept all the tables in a MDB file and all the forms in a seperate accdb file. All the tables of MDF file is link in the accdb file. As long as I was working in the local computer, everything worked fine. But when I put the backend MDB file in the server, and front end ACCDB file in the client computer, quite frequently the database (MDB) file is getting corrupt. Has...
7
23880
by: preeny8 | last post by:
Hi there, I recently updated to Access 2007, and I'm getting a couple of errors that i'm not sure how to deal with. I worked with a lot of databases in Access 2003 (.mdb), and for some reason some of these databases will not open in access 2007. The errors I get say: "An error occured while loading 'Form_frm_tabstrip'. do you want to continue loading the project?" I can choose yes, no or help. On choosing yes, another message box...
3
3395
by: philqw78 | last post by:
Using quite a simple Access DBase across the network I occasionally get this error: The dbase is split with front ends on user's PC's and a back end on the shared drive. This has happened to me whilst editing and backing up the back end of the database and to one other user. She was using the front end copy on the shared drive instead of her PC though. What could be causing this? The dbase has been corrupted once so far because of it....
0
8832
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
9566
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
9388
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...
0
9254
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...
1
6800
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
4879
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3319
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
2
2791
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2217
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.