467,889 Members | 1,390 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,889 developers. It's quick & easy.

Problems Opening Access 2003 mde Files In Access 2002

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
  • viewed: 3082
Share:
7 Replies
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
"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
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
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
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
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
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.

Similar topics

28 posts views Thread by Neil Ginsberg | last post: by
2 posts views Thread by Joseph Macari | last post: by
reply views Thread by Just another Joe Programmer | last post: by
12 posts views Thread by DanB | last post: by
1 post views Thread by Anindya C via DotNetMonster.com | last post: by
reply views Thread by MrMoon | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.