Corrupt Database?

[Guest]

I have an Access db converted to 2002/03 and I've compiled an MDE file out of
it. All my users with Access 2003 is able to run the MDE fine but one user
running on Access XP kept giving this error when I tried to open the MDE file:

"The Visual Basic for Application project in the database is corrupt."

Then it prompts if I want to repair the database and restart but it still
won't start. The funny thing is that it is able to run the actual MDB file
without problems so why not the MDE file? Is there known incompatibility or
bug? Thanks.
ck

 

[Guest]

Hi.

I hate to recommend installing MS Office XP SP-3 because of the problems it
caused for Access, but this is one of the issues that this service pack
fixed. The binaries for Access 2002 and 2003 are different enough that
saving the database in Access 2003 *.MDB format even one time, then opening
it in Access 2002 and converting it to Access 2002 *.MDE format will make the
Access 2002 *.MDE database file incompatible with Access 2002.

Before installing MS Office XP SP-3 on the Access 2002 computer though, I
would try to create a new Access 2002 *.MDB database file, import all objects
from the original Access 2002 *.MDB database file, compile the code, then
create a new Access 2002 *.MDE database file and see whether this new *.MDE
database file runs in Access 2002. The Access 2003 computers should have no
problem running either of the Access 2002 versions of the *.MDE database file.

And if that didn't work, I'd try the Access 2000 database format (even
though it doesn't have a few of the nifty features of the later versions).
And if that didn't work, I'd seriously consider purchasing and installing MS
Office 2003 for the MS Office XP computer. And if that option didn't get
approved, I'd tell the MS Office XP user, "Sorry. This *.MDE database file
run won't run with Access 2002."

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
Beware to those who use munged addresses: known newsgroup E-mail harvesters
for spammers are (e-mail address removed) and (e-mail address removed)

- - -
When you see correct answers to your question posted in Microsoft's Online
Community, please sign in to the Community and mark these posts as "Answers,"
so that all may benefit by filtering on "Answered questions" and quickly
finding the right answers to similar questions. Remember that questions
answered the quickest are often from those who have a history of rewarding
the contributors who have taken the time to answer questions correctly.

 

[Tony Toews]

I have an Access db converted to 2002/03 and I've compiled an MDE file out of
it. All my users with Access 2003 is able to run the MDE fine but one user
running on Access XP kept giving this error when I tried to open the MDE file:

"The Visual Basic for Application project in the database is corrupt."

Actually this is a misleading error message. You've created the MDE
in A2003. A2002 aka Access XP can't read the code for A2003 MDEs so
it gives you this highly misleading message.

You will need to create the MDE in A2002. Then the A2002 and A2003
systems can execute the MDE.

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

 

[Guest]

Hi, Tony.

A2002 aka Access XP can't read the code for A2003 MDEs so
it gives you this highly misleading message.

Perhaps the Canadian version of Access 2002 gives this error message, but
the U.S. version doesn't. When one attempts to open an Access 2003 *.MDE
database file in the U.S. version of Access 2002, one receives "This database
is in an unrecognized format" error message, because it can't open the
database file, let alone check the VBA Project after opening the file. I
imagine CK's Access 2002 version in Singapore matches the U.S. version error
message, but I don't know for sure.

In the U.S. version, the error message CK is reporting indicates that the
database file was once saved in Access 2003 prior to being converted to an
Access 2002 *.MDE database file and that MS Office XP SP-3 has not yet been
installed on the computer.

One thing I forgot to mention in my earlier message is that I try to use
/decompile on the database files after converting them to an earlier version
(or prior to opening them with an earlier version), then re-compiling the
code, in order to eliminate code gremlins from other versions of Access.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
Beware to those who use munged addresses: known newsgroup E-mail harvesters
for spammers are (e-mail address removed) and (e-mail address removed)

- - -
When you see correct answers to your question posted in Microsoft's Online
Community, please sign in to the Community and mark these posts as "Answers,"
so that all may benefit by filtering on "Answered questions" and quickly
finding the right answers to similar questions. Remember that questions
answered the quickest are often from those who have a history of rewarding
the contributors who have taken the time to answer questions correctly.

 

[Guest]

Thanks 69 Camaro. Will try out some of your suggestions you mentioned
earlier. I guess the best thing to avoid any other future problems is to have
them all standardized on XP 2003.
ck

 

[Guest]

Thanks Tony. Will try your suggestion and see what happens.
ck

 

[Tony Toews]

Perhaps the Canadian version of Access 2002 gives this error message, but
the U.S. version doesn't. When one attempts to open an Access 2003 *.MDE
database file in the U.S. version of Access 2002, one receives "This database
is in an unrecognized format" error message, because it can't open the
database file, let alone check the VBA Project after opening the file. I
imagine CK's Access 2002 version in Singapore matches the U.S. version error
message, but I don't know for sure.

In the U.S. version, the error message CK is reporting indicates that the
database file was once saved in Access 2003 prior to being converted to an
Access 2002 *.MDE database file and that MS Office XP SP-3 has not yet been
installed on the computer.

I meant to get back to you on this and kept procrastinating.

You may receive a "The Visual Basic for Applications project in the
database is corrupt" error message when you try to open an object that
is in a compiled database or in a compiled project in Access 2002, in
Access 2002 SP1, or in Access 2002 SP2
http://support.microsoft.com/?kbid=897764

So if CK's user running A2002 hasn't installed SP3 then that could be
causing this message.

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

 

[Guest]

Thanks for clarifying, Tony.

Gunny

P.S. Sorry it took me so long to reply. I've been off-line for a while.