Solved

MS Access 2010 Reports Error

Posted on 2013-06-14
7
544 Views
Last Modified: 2013-06-16
I am getting an error when trying to open a Report in MS Access 2010,
"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.  You should back up your database before attempting to open the database and delete the VBA project"
This is occurring for all reports.   Any ideas?
0
Comment
Question by:fjkaykr11
  • 3
  • 3
7 Comments
 
LVL 57

Assisted Solution

by:Jim Dettman (Microsoft MVP/ EE MVE)
Jim Dettman (Microsoft MVP/ EE MVE) earned 375 total points
ID: 39248936
Something's going on; this is starting to popup all over.

Have you moved the DB from one machine to another and posssibly gone from 32 to 64 bits?  What format is the DB in?

Jim.
0
 
LVL 3

Author Comment

by:fjkaykr11
ID: 39248982
Jim good catch. Yes we did go from 32 to 64 bit.  I am guessing I should downgrade back to 32 bit?  I wanted to post here before I do this because we have it on more than 1 computer.
MS Access is 64 bit but you also asked the format of the database, can you elaborate on the format and how can I verify what it is in.   Thanks
0
 
LVL 84

Assisted Solution

by:Scott McDaniel (Microsoft Access MVP - EE MVE )
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 125 total points
ID: 39249797
Note that most recommend that you NOT move to 64-bit Office unless you really, really need the features provided there.

Regarding the format - is this an ACCDB file or an MDB file?
0
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

 
LVL 57

Assisted Solution

by:Jim Dettman (Microsoft MVP/ EE MVE)
Jim Dettman (Microsoft MVP/ EE MVE) earned 375 total points
ID: 39250022
By format, I meant a regular DB or a DB with source code stripped out (MDB/MDE or ACCDB/ACCDE).

Access 2010 did have a problem with DB's that moved from 32 to 64 bits and being in a MDE/ACCDE format.

If you are in a compiled only format, check help about and see if SP1 is installed.  If so, then you'll need to recreate the MDE/ACCDE in 2010 with SP1 for it to work properly.

  There is also a problem with the built-in wizards in 2010 after a SP1 update:

Acc2010: You receive an error in Microsoft Access using the built-in wizards after installing Microsoft Office 2010 SP1
http://support.microsoft.com/kb/2581301

 Basically the same issue, but the wizard files were not updated correctly on the SP1 install.

Jim.
0
 
LVL 3

Author Comment

by:fjkaykr11
ID: 39250422
Thanks for the updated info.  I think it is ACCDB not MDB but I will have tocheck when I get a chance.     I am not sure how to verify it is a regular DB or a DB with source code stripped out (MDB/MDE or ACCDB/ACCDE).  If it is in a compiled only format with SP1, how do you
 recreate the MDE/ACCDE ? Thanks again.
0
 
LVL 57

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 375 total points
ID: 39251241
<<I  am not sure how to verify it is a regular DB or a DB with source code stripped out (MDB/MDE or ACCDB/ACCDE). >>

 Just try to open the DB with the shift key held down and then try and look at some code.

<< If it is in a compiled only format with SP1, how do you
 recreate the MDE/ACCDE ? >>

  You need the original MDB/ACCDB and covert it to a MDE/ACCDE.

Jim.
0
 
LVL 3

Author Closing Comment

by:fjkaykr11
ID: 39251785
thanks again. I will follow up with this when I get a chance, it might take a while.
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…

792 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