By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,010 Members | 2,774 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,010 IT Pros & Developers. It's quick & easy.

Problems Opening Access 2003 mde Files In Access 2002

P: n/a
I have several Access 2003 mde databases. When I try to open them in
Access 2002 I get the following error:

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

Interestingly I can open the mdb files of the same 2003 databases in
Access 2002 without problems. To my understanding the file formats of
2002 and 2003 are the same and this problem shouldn't exist. And why
is it only the mde files that are giving the problem?

Has anyone else seen this behaviour? Any help would be appreciated.
Nov 12 '05 #1
Share this Question
Share on Google+
7 Replies


P: n/a
I thought that Access 2003 could only create MDE files if the MDB was in
Access 2003 format. Since Access 2002 cannot work with the Access 2003
format, that would explain why it can't handle the MDE.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(No private e-mails, please)

"Wayne Aprato" <cq*******@volcanomail.com> wrote in message
news:4d**************************@posting.google.c om...
I have several Access 2003 mde databases. When I try to open them in
Access 2002 I get the following error:

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

Interestingly I can open the mdb files of the same 2003 databases in
Access 2002 without problems. To my understanding the file formats of
2002 and 2003 are the same and this problem shouldn't exist. And why
is it only the mde files that are giving the problem?

Has anyone else seen this behaviour? Any help would be appreciated.

Nov 12 '05 #2

P: n/a
"Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message news:<_Q***************@twister01.bloor.is.net.cab le.rogers.com>...
I thought that Access 2003 could only create MDE files if the MDB was in
Access 2003 format. Since Access 2002 cannot work with the Access 2003
format, that would explain why it can't handle the MDE.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(No private e-mails, please)

"Wayne Aprato" <cq*******@volcanomail.com> wrote in message
news:4d**************************@posting.google.c om...
I have several Access 2003 mde databases. When I try to open them in
Access 2002 I get the following error:

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

Interestingly I can open the mdb files of the same 2003 databases in
Access 2002 without problems. To my understanding the file formats of
2002 and 2003 are the same and this problem shouldn't exist. And why
is it only the mde files that are giving the problem?

Has anyone else seen this behaviour? Any help would be appreciated.


Hi Douglas. The Default File Format choices in Access 2003 are
"Access 2000" and "Access 2002/2003". An Access 2002 mdb can be
compiled as an mde in Access 2003 if the default file format was set
to Access 2002. Access 2002 sets the default file format to 2000 when
it is first opened. If this isn't changed, you are correct in saying
that Access 2003 can't compile it to an mde.

Regards.
Nov 12 '05 #3

P: n/a
cq*******@volcanomail.com (Wayne Aprato) wrote:
I have several Access 2003 mde databases. When I try to open them in
Access 2002 I get the following error:

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

Interestingly I can open the mdb files of the same 2003 databases in
Access 2002 without problems. To my understanding the file formats of
2002 and 2003 are the same and this problem shouldn't exist. And why
is it only the mde files that are giving the problem?


Yes, this is expected behaviour. Despite being the same file format A2002 can't open
A2003 created MDEs.

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
Nov 12 '05 #4

P: n/a
Tony Toews <tt****@telusplanet.net> wrote in message news:<rk********************************@4ax.com>. ..
cq*******@volcanomail.com (Wayne Aprato) wrote:
I have several Access 2003 mde databases. When I try to open them in
Access 2002 I get the following error:

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

Interestingly I can open the mdb files of the same 2003 databases in
Access 2002 without problems. To my understanding the file formats of
2002 and 2003 are the same and this problem shouldn't exist. And why
is it only the mde files that are giving the problem?


Yes, this is expected behaviour. Despite being the same file format A2002 can't open
A2003 created MDEs.

Tony


Thanks Tony. It's never easy is it?
Nov 12 '05 #5

P: n/a
cq*******@promail.com (Wayne Aprato) wrote:
Yes, this is expected behaviour. Despite being the same file format A2002 can't open
A2003 created MDEs.

Thanks Tony. It's never easy is it?


The error message is rather misleading. It'll be fixed soon.

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
Nov 12 '05 #6

P: n/a
Tony Toews <tt****@telusplanet.net> wrote in message news:<7g********************************@4ax.com>. ..
cq*******@promail.com (Wayne Aprato) wrote:
Yes, this is expected behaviour. Despite being the same file format A2002 can't open
A2003 created MDEs.

Thanks Tony. It's never easy is it?


The error message is rather misleading. It'll be fixed soon.

Tony


Tony, Do you have any idea when they are going to patch the bug with
the linked table manager ie. it doesn't show linked tables until the
appropriate version of "Accwiz.dll" is registered.

Regards.
Nov 12 '05 #7

P: n/a
cq*******@promail.com (Wayne Aprato) wrote:
Tony, Do you have any idea when they are going to patch the bug with
the linked table manager ie. it doesn't show linked tables until the
appropriate version of "Accwiz.dll" is registered.


No idea. MS is definitely aware of this problem.

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
Nov 12 '05 #8

This discussion thread is closed

Replies have been disabled for this discussion.