2000 mde with xp

[John]

Hi

Will 2k mde run on access xp? Problem is that I need to send an access 2k
database to a remote client and I obviously need to turn it into mde before
sending it.

Thanks

Regards

 

[Cheryl Fischer]

John,

To create an MDE of an Access 2000 format database, you must use Access
2000. Despite the fact that Access XP can create databases in Access 2000,
it cannot create MDEs of them.

 

[John]

Would an access 2000 mde run on access xp though?

Regards

 

[Cheryl Fischer]

Yes, Access 2002 can open and run an Access 2000 MDE. Without issues?
Maybe - maybe not; it depends on the design of the 2000 database. One
"gotcha" that comes to mind might be the location(s) of references. Also,
keep in mind that you would need to keep a copy of Access 2000 on hand for
whenever the original MDB needs to be updated and the MDE re-made, as only
Access 2000 can create an Access 2000 MDE.

If I were in your position - with the database going to a client - I would
want to test the MDE on a box using Office XP before I sent it out.

hth,

 

[david epsom dot com dot au]

2K mde will run 'on' access xp, but requires presence
of Access 2K, or possibly just presence of Office 2K
runtime files.

The project has a reference to the Access object library,
msacc9.olb.
In an MDB, this will automatically convert from A2K to
XP. With an MDE, this reference is stuck, so you need
at least msacc9.olb, and possibly other things.

(david)

 

[Tony Toews]

2K mde will run 'on' access xp, but requires presence
of Access 2K, or possibly just presence of Office 2K
runtime files.

The project has a reference to the Access object library,
msacc9.olb.
In an MDB, this will automatically convert from A2K to
XP. With an MDE, this reference is stuck, so you need
at least msacc9.olb, and possibly other things.

I'm not sure I'm going to agree with you on this issue. I think
Access is smart enough to change that reference in the MDEs. Or at
least I've read enough postings about A2002 running A2000 MDEs.

I was just going to try it but I realized I have A97, A2000 and A2002
installed on this laptop so that wouldn't be a valid test.

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

 

[david epsom dot com dot au]

In our office, A2K MDE's will run in Access XP, but only
on the machines where Access 2000 is installed.

The Access type library is compatible between A2K-A2002,
and OLE early binding should work regardless of which
version is installed. (Not between A97 and A2K, because
the type library compatibility got broken).

However, I'll believe OLE compatibility works in Access
only when I get my nose rubbed in it.

Beyond that, my theories are just speculation.

(david)

 

[Sean]

I successfully run a large 2k mde on an office XP site, no access 2k
installed what so ever.
The mde references Access object library (msacc.olb) and office object
library (mso.dll???) amongst other references , this same mde can be
compiled for access 97 sites and for access 2k sites, the references
automatically change depending on whats there.

David, this is not a theory, its implemented out there and has been
running fine for quite a while.

 

[david epsom dot com dot au]

I successfully run a large 2k mde on an office XP site, no access 2k
installed what so ever.

Ok, we will have to see what works for us out in the wild.
Note: we have library mde's as well as a CurrentDB.

The mde references Access object library (msacc.olb) and office object
library (mso.dll???) amongst other references , this same mde can be
compiled for access 97 sites and for access 2k sites, the references
automatically change depending on whats there.

The references automatically change when you /convert/ from from 97 to 2K.
(And from 2K to XP).
You aren't suggesting that you can run an A97 mde on access 2K?

(david)

 

[Tony Toews]

You aren't suggesting that you can run an A97 mde on access 2K?

Not at all. However it's my understanding that A2002 will happily run
at A2000 MDE. But it won't make an A2000 format 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