"VBA project is corrupted", 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

[Steve Jorgensen]

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æ" <zl***********@sb.t-com.hr>
wrote:

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

[Arno R]

"Steve Jorgensen" <no****@nospam.nospam> schreef in bericht news:lr********************************@4ax.com...

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

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

[Zlatko Matic]

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" <ar***********@tiscali.nl> je napisao u poruci interesnoj
grupi:43********************@dreader2.news.tiscali .nl...

"Steve Jorgensen" <no****@nospam.nospam> schreef in bericht
news:lr********************************@4ax.com...

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

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

[Arno R]

"Zlatko Matic" <zl***********@sb.t-com.hr> schreef in bericht news:de**********@ss405.t-com.hr...

OK., but what abou Access 2002, which should produce same type of .mde as
Access 2003 ?

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

[Ed Robichaud]

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

an Access2003 made MDE will NOT work under AccessXP/2002

-Ed

"Zlatko Matic" <zl***********@sb.t-com.hr> wrote in message
news:de**********@ss405.t-com.hr...

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" <ar***********@tiscali.nl> je napisao u poruci interesnoj
grupi:43********************@dreader2.news.tiscali .nl...

"Steve Jorgensen" <no****@nospam.nospam> schreef in bericht
news:lr********************************@4ax.com...

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

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

[Steve Jorgensen]

On Mon, 22 Aug 2005 18:33:37 +0200, "Zlatko Matic" <zl***********@sb.t-com.hr>
wrote:

OK., but what abou Access 2002, which should produce same type of .mde as
Access 2003 ?

It shouldn't, and it doesn't.

[Zlatko Matic]

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" <ar***********@tiscali.nl> je napisao u poruci interesnoj
grupi:43********************@dreader2.news.tiscali .nl...
"Zlatko Matic" <zl***********@sb.t-com.hr> schreef in bericht
news:de**********@ss405.t-com.hr...

OK., but what abou Access 2002, which should produce same type of .mde as
Access 2003 ?

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

[Arno R]

"Zlatko Matic" <zl***********@sb.t-com.hr> schreef in bericht news:de**********@ss405.t-com.hr...

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.

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

Arno R

[Zlatko Matic]

OK. Thanks.

"Arno R" <ar***********@tiscali.nl> je napisao u poruci interesnoj
grupi:43********************@dreader2.news.tiscali .nl...

"Zlatko Matic" <zl***********@sb.t-com.hr> schreef in bericht
news:de**********@ss405.t-com.hr...

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.

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

Arno R