MS Access data conversion - ADE2003 and Access 2000 mdb

Author

ADE2003 and Access 2000 mdb

David Shorthouse

2005-09-11, 8:46 pm

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

--
____________________
__________
Remove "_SPAM" to reply directly.

'69 Camaro

2005-09-11, 8:46 pm

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.

"David Shorthouse" < davidshorthouse@shaw
_SPAM.ca> wrote in message
news:eK$kmhxtFHA.1284@tk2msftngp13.phx.gbl...
> 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
>
> --
> ____________________
__________
> Remove "_SPAM" to reply directly.
>

Bret Reid Jones

2005-11-08, 4:15 pm

gfdgfdhg
"David Shorthouse" < davidshorthouse@shaw
_SPAM.ca> wrote in message
news:eK$kmhxtFHA.1284@tk2msftngp13.phx.gbl...
> 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
>
> --
> ____________________
__________
> Remove "_SPAM" to reply directly.
>
>

Sponsored Links