2000 v 2003 Automatic choose correct version

[bobdydd]

Hi Everybody

I still have plenty of databases written in Access 2000 although I
would like to write future databases in Access 2003.

Assuming I have both versions on the same machine, is it possible to
have the correct version of Access start according to whether the .mdb
file is written in 2000 or 2003?

Thanks in a advance.

[John Vinson]

On 16 Jan 2007 11:45:26 -0800, "bobdydd"
<re**************@yahoo.co.ukwrote:

>Hi Everybody

I still have plenty of databases written in Access 2000 although I
would like to write future databases in Access 2003.

Assuming I have both versions on the same machine, is it possible to
have the correct version of Access start according to whether the .mdb
file is written in 2000 or 2003?

Thanks in a advance.

Access2003 will open and work with A2000 databases perfectly well - in
fact it defaults to creating new databases in 2000 format.

If you wish, you can create Shortcuts which open one version or the
other as you choose; but no, Access will not detect which version
you're opening and then automagically call another instance of
msaccess.exe. You might be able to write a Visual Basic program to do
so but that would really be overkill!

John W. Vinson[MVP]

[Douglas J. Steele]

Access 2003 works fine with Access 2000 databases (no conversion required:
Access 2000 format is actually the default file format for Access 2003), so
it's really a moot point.

Such a capability isn't built into Access, but there are 3rd party products
out there that will do this for you:

Access Opener http://www.openaccess.co.za/BlackAnd...cessOpener.htm
ACCVER http://www.aylott.com.au/software.htm
Total Access Startup http://www.fmsinc.com/products/startup

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
"bobdydd" <re**************@yahoo.co.ukwrote in message
news:11**********************@51g2000cwl.googlegro ups.com...

Hi Everybody

I still have plenty of databases written in Access 2000 although I
would like to write future databases in Access 2003.

Assuming I have both versions on the same machine, is it possible to
have the correct version of Access start according to whether the .mdb
file is written in 2000 or 2003?

Thanks in a advance.

[bobdydd]

Douglas J. Steele wrote:

Access 2003 works fine with Access 2000 databases (no conversion required:
Access 2000 format is actually the default file format for Access 2003), so
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele

Those 3rd party product will satisfy my requirements. Thanks to
everyone who replied.

Regards Bob