cannot open database because VBA project cannot be read

  • Follow


Without any provocation that I can think of, I got the message above after 
opening my database this morning.  The message further states that the only 
way that the database can be opened is to delete the VBA project and all code 
from modules, forms, and reports.  This is a highly undesirable option.  Yes, 
I do have backups I can resort to, but I'd rather not if there is a 
workaround.

The database has a meager bit of VBA associated with some forms and reports, 
and I hadn't touched any of it for some time.  Has anybody seen this error?  
Access help was not helpful.
0
Reply Utf 11/15/2007 1:58:01 AM

AccessMan <AccessMan@discussions.microsoft.com> wrote:

>Without any provocation that I can think of, I got the message above after 
>opening my database this morning.  The message further states that the only 
>way that the database can be opened is to delete the VBA project and all code 
>from modules, forms, and reports.  This is a highly undesirable option.  Yes, 
>I do have backups I can resort to, but I'd rather not if there is a 
>workaround.

I don't ever recall seeing this particular message although my memory
isn't perfect.

1) Make a copy

2) Try importing all the objects into a new database

3) Try a decompile.  http://www.granite.ab.ca/access/decompile.htm

Tony
-- 
Tony Toews, Microsoft Access MVP
   Please respond only in the newsgroups so that others can 
read the entire thread of messages.
   Microsoft Access Links, Hints, Tips & Accounting Systems at 
http://www.granite.ab.ca/accsmstr.htm
   Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
0
Reply Tony 11/15/2007 2:55:22 AM


Tony:

Thanks for the response.  Just to clarify, do you mean for me to import the 
objects from the troubled database (or a copy of it) into a blank one?  Does 
the fact that the troubled database had not been compiled change anything?

"Tony Toews [MVP]" wrote:

> AccessMan <AccessMan@discussions.microsoft.com> wrote:
> 
> >Without any provocation that I can think of, I got the message above after 
> >opening my database this morning.  The message further states that the only 
> >way that the database can be opened is to delete the VBA project and all code 
> >from modules, forms, and reports.  This is a highly undesirable option.  Yes, 
> >I do have backups I can resort to, but I'd rather not if there is a 
> >workaround.
> 
> I don't ever recall seeing this particular message although my memory
> isn't perfect.
> 
> 1) Make a copy
> 
> 2) Try importing all the objects into a new database
> 
> 3) Try a decompile.  http://www.granite.ab.ca/access/decompile.htm
> 
> Tony
> -- 
> Tony Toews, Microsoft Access MVP
>    Please respond only in the newsgroups so that others can 
> read the entire thread of messages.
>    Microsoft Access Links, Hints, Tips & Accounting Systems at 
> http://www.granite.ab.ca/accsmstr.htm
>    Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
> 
0
Reply Utf 11/15/2007 3:57:00 AM

AccessMan <AccessMan@discussions.microsoft.com> wrote:

>Thanks for the response.  Just to clarify, do you mean for me to import the 
>objects from the troubled database (or a copy of it) into a blank one?  

Yes.  

>Does 
>the fact that the troubled database had not been compiled change anything?

No.

Tony

-- 
Tony Toews, Microsoft Access MVP
   Please respond only in the newsgroups so that others can 
read the entire thread of messages.
   Microsoft Access Links, Hints, Tips & Accounting Systems at 
http://www.granite.ab.ca/accsmstr.htm
   Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
0
Reply Tony 11/15/2007 5:20:12 AM

Sadly, I encountered the same error message after initiating the import.

"Tony Toews [MVP]" wrote:

> AccessMan <AccessMan@discussions.microsoft.com> wrote:
> 
> >Thanks for the response.  Just to clarify, do you mean for me to import the 
> >objects from the troubled database (or a copy of it) into a blank one?  
> 
> Yes.  
> 
> >Does 
> >the fact that the troubled database had not been compiled change anything?
> 
> No.
> 
> Tony
> 
> -- 
> Tony Toews, Microsoft Access MVP
>    Please respond only in the newsgroups so that others can 
> read the entire thread of messages.
>    Microsoft Access Links, Hints, Tips & Accounting Systems at 
> http://www.granite.ab.ca/accsmstr.htm
>    Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
> 
0
Reply Utf 11/15/2007 1:32:02 PM

4 Replies
1858 Views

(page loaded in 2.987 seconds)

Similiar Articles:
















7/24/2012 1:05:35 PM


Reply: