ADE2003 and Access 2000 mdb

[David Shorthouse]

Hello folks,

I'm wanting to build an Access 2000 mde to make it more compatible with
all the pool of potential clients, but only have Access 2003 on my
development machine and don't want to install anything other than this. I
converted my Access 2003 mdb to a 2000 file format and then used the Access
2003 Developer Extensions to make the mde. But, is it really an Access 2000
mde or did ADE convert it back to a 2003 version file prior to making the
mde? I have no way of testing this and would like to know if someone has
investigated this already.

Thanks,

Dave

 

['69 Camaro]

Hi, Dave.

I'm wanting to build an Access 2000 mde to make it more compatible with
all the pool of potential clients, but only have Access 2003 on my
development machine and don't want to install anything other than this.

You really, really should have the same version of Access in which to
produce database applications for your clients. The best method is to
produce the application on the earliest version, test it thoroughly, then
convert a copy to the newer version, test that copy thoroughly, then
distribute the appropriate version to each client. You'll have a lot fewer
headaches and support calls that way.

But, is it really an Access 2000 mde or did ADE convert it back to a 2003
version file prior to making the mde? I have no way of testing this

Of course you can test this. Open the MDE file's Database Window. Look at
the title bar. It lists the database file format for you. For an Access
2000 MDE, you should see:

<Database Name> : Database (Access 2000 file format)

For an Access 2003 MDE, you should see:

<Database Name> : Database (Access 2002 - 2003 file format)

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

 

[Bret Reid Jones]

gfdgfdhg