Hi Secret Squirrel,
It depends somewhat on your operating system, especially if you need to
include Access 97 into the mix, which you didn't mention. See the following
article by Access MVP Allen Browne:
Errors using multiple versions of Access under Vista
http://allenbrowne.com/bug-17.html
One really frustrating issue that you very likely will experience is a
L-O-N-G wait when switching between versions. If your PC hardware is older,
like mine is, you might as well get up to stretch and take a coffee break if
2007 and 2003 are on the same machine. However, there is a solution to this
problem if you are willing to install additional (free) software. You can
download and install Microsoft Virtual PC for free. You then create a virtual
machine (ie. load an operating system) and load the version of Access (or
Office) that you want, plus all of the service packs. Then, you create a
second virtual machine to load the next version of Access (or Office). You
will need to check the licensing agreement for your version of Windows, as
this arrangement may require you to obtain additional licences for Windows
and/or Office. But, Virtual PC is free. It will prevent problems that can
crop up from having multiple versions of Access on one machine.
Tom Wickerath
Microsoft Access MVP
http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________