Unfortunately, the default executable associated with an MDB file is always
changed to the last used version of Access. In other words, if your users
open Access 97, their MDB files will all be associated with Access 97, while
it'll be changed back to Access 2007 after using the runtime.

You might need to look into 3rd party software that will open the database
with the appropriate version of Access.

The ones with which I'm familiar (in order of cost from cheapest to most
expensive) are:

AccessOpener from Black and White Software
http://www.openaccess.co.za/BlackAndWhiteInc/AccessOpener.htm
Accver from David Aylott http://www.aylott.com.au/software.htm
Total Access Startup from FMS http://www.fmsinc.com/products/startup/

One option would be to place the path of the msaccess.exe in the
shortcuts.   That's obviously a PITA but maybe sufficient for your
requirements.

In the target of the shortcut you'd put something like

"C:\Program Files\Microsoft Office 2007\OFFICE12\MSACCESS.EXE" "Q:\1
access\Fleet Mgmt\Service.mdb"

But you'd also need to do the same thing for the A97 shortcuts.
Obviously this won't help you if users use Windows Explorer to open
MDB/MDEs.

Also there will be a delay as the users switch between A97 and A2007.
Ensure you have the A2007SP1 runtime installed to minimize this delay.

Tony

Access 2000 and later can't open Access 97 MDE files, so converting the "must
stay in 97 format!" dbs to MDE files would prevent accidental conversion.
There's also probably a registry entry for Access 2007 that prevents a user
from being prompted to either convert or enable the older version for the
current version.  I'll see if I can find a link.

Chris
Microsoft MVP