By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,510 Members | 1,430 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,510 IT Pros & Developers. It's quick & easy.

2000 v 2003 Automatic choose correct version

P: n/a
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.

Jan 16 '07 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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]
Jan 16 '07 #2

P: n/a
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.

Jan 16 '07 #3

P: n/a

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

Jan 16 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.