Problems Opening Access 2003 mde Files In Access 2002

[Wayne Aprato]

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.

[Douglas J. Steele]

Re: Problems Opening Access 2003 mde Files In Access 2002

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" <cqdigital@volc anomail.com> wrote in message
news:4d9a5a66.0 402250000.60720 90c@posting.goo gle.com...[color=blue]
> 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.[/color]

[Wayne Aprato]

Re: Problems Opening Access 2003 mde Files In Access 2002

"Douglas J. Steele" <NOSPAM_djsteel e@NOSPAM_canada .com> wrote in message news:<_Q%_b.303 0$Yf.558@twiste r01.bloor.is.ne t.cable.rogers. com>...[color=blue]
> 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" <cqdigital@volc anomail.com> wrote in message
> news:4d9a5a66.0 402250000.60720 90c@posting.goo gle.com...[color=green]
> > 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.[/color][/color]

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.

[Tony Toews]

Re: Problems Opening Access 2003 mde Files In Access 2002

cqdigital@volca nomail.com (Wayne Aprato) wrote:
[color=blue]
>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."
>
>Interestingl y 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?[/color]

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

[Wayne Aprato]

Re: Problems Opening Access 2003 mde Files In Access 2002

Tony Toews <ttoews@teluspl anet.net> wrote in message news:<rk7q30djp ld9595imc2u0h5e 8ds6jc0cbc@4ax. com>...[color=blue]
> cqdigital@volca nomail.com (Wayne Aprato) wrote:
>[color=green]
> >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."
> >
> >Interestingl y 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?[/color]
>
> Yes, this is expected behaviour. Despite being the same file format A2002 can't open
> A2003 created MDEs.
>
> Tony[/color]

Thanks Tony. It's never easy is it?

[Tony Toews]

Re: Problems Opening Access 2003 mde Files In Access 2002

cqdigital@proma il.com (Wayne Aprato) wrote:
[color=blue][color=green]
>> Yes, this is expected behaviour. Despite being the same file format A2002 can't open
>> A2003 created MDEs.
>>[/color]
>Thanks Tony. It's never easy is it?[/color]

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

[Wayne Aprato]

Re: Problems Opening Access 2003 mde Files In Access 2002

Tony Toews <ttoews@teluspl anet.net> wrote in message news:<7g4t30d35 nubo43skilq4qis 2urrf29n76@4ax. com>...[color=blue]
> cqdigital@proma il.com (Wayne Aprato) wrote:
>[color=green][color=darkred]
> >> Yes, this is expected behaviour. Despite being the same file format A2002 can't open
> >> A2003 created MDEs.
> >>[/color]
> >Thanks Tony. It's never easy is it?[/color]
>
> The error message is rather misleading. It'll be fixed soon.
>
> Tony[/color]

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.

[Tony Toews]

Re: Problems Opening Access 2003 mde Files In Access 2002

cqdigital@proma il.com (Wayne Aprato) wrote:
[color=blue]
>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.[/color]

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