"VBA project is corrupted", Access2003--Access2002

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

re: "VBA project is corrupted", Access2003--Access2002

Unlike mbb files, mde files only work with the version of MS Access that they
were created with.

On Mon, 22 Aug 2005 13:57:11 +0200, "Zlatko Matiæ" <zlatko.matic1@sb.t-com.hr>
wrote:
[color=blue]
>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
>[/color]

re: "VBA project is corrupted", Access2003--Access2002

"Steve Jorgensen" <nospam@nospam.nospam> schreef in bericht news:lrgjg1t6lr9cmlqv1dsvpdt015ju9autdl@4ax.com...[color=blue]
> Unlike mbb files, mde files only work with the version of MS Access that they
> were created with.
> [/color]

Hi Steve, you are not quite right here...
I guess you mean that if one needs an Access 2000.mde, this mde needs to be created with the specific version of Access.

An Access 2000.mde WILL work with Access 2003 but...
An Access 2003.mde will NOT work with Access 2000
You can NOT create an Access 2000.mde with Access 2003


Arno R

re: "VBA project is corrupted", Access2003--Access2002

OK., but what abou Access 2002, which should produce same type of .mde as
Access 2003 ?
By the way, I prepared Access 2000 version of .mde, by using MDE 2000
program (RV Software), with same result....

Zlatko

"Arno R" <arraNOcomSPAM@tiscali.nl> je napisao u poruci interesnoj
grupi:4309e50d$0$728$5fc3050@dreader2.news.tiscali .nl...

"Steve Jorgensen" <nospam@nospam.nospam> schreef in bericht
news:lrgjg1t6lr9cmlqv1dsvpdt015ju9autdl@4ax.com...[color=blue]
> Unlike mbb files, mde files only work with the version of MS Access that
> they
> were created with.
>[/color]

Hi Steve, you are not quite right here...
I guess you mean that if one needs an Access 2000.mde, this mde needs to be
created with the specific version of Access.

An Access 2000.mde WILL work with Access 2003 but...
An Access 2003.mde will NOT work with Access 2000
You can NOT create an Access 2000.mde with Access 2003


Arno R

re: "VBA project is corrupted", Access2003--Access2002

"Zlatko Matic" <zlatko.matic1@sb.t-com.hr> schreef in bericht news:decup0$24s$1@ss405.t-com.hr...[color=blue]
> OK., but what abou Access 2002, which should produce same type of .mde as
> Access 2003 ?[/color]

I think it will be the same for Access 2002. (Can't verify because I don't have that version.)
Btw: I would be very surprized if the Access 2002.mde is the same type as the Access 2003.mde
MAYBE you can create an Access 2002.mde with Access 2003 (I doubt it, but can't verify)
From your original post I read and believe that it doesn't work ...
so that means the 2003.mde is NOT the same format as the one you need with Access 2002 (XP)...

I bet for A2k it will look like this:
An Access 2002.mde will work with Access 2003.
An Access 2002.mde will NOT work with Access 2000.
You can NOT create an Access 2000.mde with Access 2002.
You can NOT create an Access 2003.mde with Access 2002 ? (I think ...)

So mde's starting from A2k are upwards compatible it seems to me, but NOT downwards.

Because of the default fileformat (A2k) for the mdb's starting from A2k it is all a bit confusing...

Arno R

re: "VBA project is corrupted", Access2003--Access2002

Same deal:
an AccessXP/2002 made MDE will work under Access2003

an Access2003 made MDE will NOT work under AccessXP/2002

-Ed

"Zlatko Matic" <zlatko.matic1@sb.t-com.hr> wrote in message
news:decup0$24s$1@ss405.t-com.hr...[color=blue]
> OK., but what abou Access 2002, which should produce same type of .mde as
> Access 2003 ?
> By the way, I prepared Access 2000 version of .mde, by using MDE 2000
> program (RV Software), with same result....
>
> Zlatko
>
> "Arno R" <arraNOcomSPAM@tiscali.nl> je napisao u poruci interesnoj
> grupi:4309e50d$0$728$5fc3050@dreader2.news.tiscali .nl...
>
> "Steve Jorgensen" <nospam@nospam.nospam> schreef in bericht
> news:lrgjg1t6lr9cmlqv1dsvpdt015ju9autdl@4ax.com...[color=green]
>> Unlike mbb files, mde files only work with the version of MS Access that
>> they
>> were created with.
>>[/color]
>
> Hi Steve, you are not quite right here...
> I guess you mean that if one needs an Access 2000.mde, this mde needs to
> be created with the specific version of Access.
>
> An Access 2000.mde WILL work with Access 2003 but...
> An Access 2003.mde will NOT work with Access 2000
> You can NOT create an Access 2000.mde with Access 2003
>
>
> Arno R
>[/color]

re: "VBA project is corrupted", Access2003--Access2002

On Mon, 22 Aug 2005 18:33:37 +0200, "Zlatko Matic" <zlatko.matic1@sb.t-com.hr>
wrote:
[color=blue]
>OK., but what abou Access 2002, which should produce same type of .mde as
>Access 2003 ?[/color]

It shouldn't, and it doesn't.

re: "VBA project is corrupted", Access2003--Access2002

OK. guys, thank you for your time and good will.
I think it is clear now that every Office version has its own .mde version
that can't wok on any other Office version.

Bye,

Zlatko

"Arno R" <arraNOcomSPAM@tiscali.nl> je napisao u poruci interesnoj
grupi:430a1444$0$716$5fc3050@dreader2.news.tiscali .nl...
"Zlatko Matic" <zlatko.matic1@sb.t-com.hr> schreef in bericht
news:decup0$24s$1@ss405.t-com.hr...[color=blue]
> OK., but what abou Access 2002, which should produce same type of .mde as
> Access 2003 ?[/color]

I think it will be the same for Access 2002. (Can't verify because I don't
have that version.)
Btw: I would be very surprized if the Access 2002.mde is the same type as
the Access 2003.mde
MAYBE you can create an Access 2002.mde with Access 2003 (I doubt it, but
can't verify)
From your original post I read and believe that it doesn't work ...
so that means the 2003.mde is NOT the same format as the one you need with
Access 2002 (XP)...

I bet for A2k it will look like this:
An Access 2002.mde will work with Access 2003.
An Access 2002.mde will NOT work with Access 2000.
You can NOT create an Access 2000.mde with Access 2002.
You can NOT create an Access 2003.mde with Access 2002 ? (I think ...)

So mde's starting from A2k are upwards compatible it seems to me, but NOT
downwards.

Because of the default fileformat (A2k) for the mdb's starting from A2k it
is all a bit confusing...

Arno R

re: "VBA project is corrupted", Access2003--Access2002

"Zlatko Matic" <zlatko.matic1@sb.t-com.hr> schreef in bericht news:deet6h$cqm$1@ss405.t-com.hr...[color=blue]
> OK. guys, thank you for your time and good will.
> I think it is clear now that every Office version has its own .mde version
> that can't wok on any other Office version.
> [/color]

I am sorry but this statement is False,
As I said: An Access2000.mde can work with Access 2002 and Access 2003

Arno R

re: "VBA project is corrupted", Access2003--Access2002

OK. Thanks.

"Arno R" <arraNOcomSPAM@tiscali.nl> je napisao u poruci interesnoj
grupi:430b16c3$0$710$5fc3050@dreader2.news.tiscali .nl...

"Zlatko Matic" <zlatko.matic1@sb.t-com.hr> schreef in bericht
news:deet6h$cqm$1@ss405.t-com.hr...[color=blue]
> OK. guys, thank you for your time and good will.
> I think it is clear now that every Office version has its own .mde version
> that can't wok on any other Office version.
>[/color]

I am sorry but this statement is False,
As I said: An Access2000.mde can work with Access 2002 and Access 2003

Arno R