Hi Catherine,
you can install two versions of Access in a workstation.
When running the instalation CD, you just have to choose a
different folder to install each version of MS-Office (if
Access97 is installed in c:\Program Files\Microsoft
Office, you can install Access 2000 in c:\Program
Files\Microsoft Office 2000, for example).
When Access97 is opened, the computer understands that any
MDB file should be opened by Access97, so the user will
try to open a 2000 database and will get a message
like "unrecognized database format". Also, when Access2000
is opened, the computer understands that any MDB file
should be opened by Access2000, and if the user tries to
open a 97 file, he will be asked to convert it.
How to deal with that?
1st alternative: open the correct Access version, and only
then open the file.
2nd alternative: create shortcuts pointing to the correct
EXE file, example:
"C:\Program Files\Microsoft Office 2000
\Office\MSACCESS.EXE" "C:\YourFolder\YourDatabase.mdb"
[]
Luiz Cláudio C. V. Rocha
São Paulo - Brazil