"VBA project is corrupte", Access2003--Access2002

[Zlatko Matiæ]

Hello.

Could somebody explain the following situation:
I have a .mdb on my notebook with Windows XP SP2 and Access 2003. I prepared
..mde and tried to use it on another computer with Windows XP SP2 and Office
XP installed on it. An error "...Your VBA project is corrupted" appeared.
When I copy .mdb to that computer, instead of .mde, it works. If I then make
the .mde on that computer, it works! If I copy the .mde then to the first
computer, it works...
What could be possible reason that my .mde doesn't work on Office XP, while
..mdb works ?

Just for information, I had also problems with ADO reference, but I solved
it by late binding instead of early binding. I also have late binding of DAO
code...

Zlatko

 

[codeman]

Hi,

if the MDE is created with MS Access 2003, you cannot use that MDE
file with MS Access XP. The MDE fileformats are not compatible.

Solution:
- create the MDE file with MS Access XP if it is used by MS Access XP
- create the MDE file with MS Access 2003 if it is used by MS Access
2003

The Codeman


Op Mon, 22 Aug 2005 13:57:40 +0200 schreef "Zlatko Matiæ"

 

[codeman]

Hi,

the VBA code in MDE file is striped, removed and replaced by an
internal code that makes the MDE files incompatible between MS Access
XP and 2003. The MDB file contains the VBA code in text, this can be
executed on both MS Access XP and 2003.

The Codeman

Op Mon, 22 Aug 2005 14:24:01 +0200 schreef codeman

 

[Zlatko Matic]

Thank you for your answer.
What about Access2000 .mde and compatibility with Access 2002 and Access
2003 ?

Zlatko

 

[Tony Toews]

What about Access2000 .mde and compatibility with Access 2002 and Access
2003 ?

A2002 and A2003 can execute A2000 MDEs just fine. A2003 can execute
an A2002 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