I have users with Office 97 installed.
I need to install Access 2003 runtime to use some of the databases I have
developed.
Last time I went down this path with a user the runtime co-opted the *.mdb
files (all access databases ran on runtime -- not a good thing).
I need to know how to set up runtime and the applications so runtime will
only fire up when using the databases I develop.
Ed Warren
Well the last occurance determines what Access version is opened just by
double-clicking on an .mdb file in Windows Explorer.
But of course you can have a shortcut on the desktop that opens the proper
version of Access' .exe file and then has a space and then shows the file to be
opened. And of course you'd want to include full filepaths above and include
each filepath in quotes if there are any spaces.
And here's a little something I wrote about Access 97 and Access 2 awhile back
that still is applicable:
Open Either Version From Windows Explorer
If you want to have Windows Explorer open up an Access document in the newest
vestion of Access (the default) OR an older version of Access:
In Windows Explorer | View | Options | File Types tab | Select New below | Call
it Open with Access 97 and give it the code of something like "C:\Program
Files\Microsoft Office 97\Office\MSACCESS.EXE".
Then if you right click on an .mdb file in Windows Explorer you will have the
choice of Open (in latest version of Access) or Open with Access 97.
Best regards,
J. Paul Schmidt, Freelance Access and ASP Developer
www.Bullschmidt.com/Access - Sample Access Database
www.Bullschmidt.com/login.asp - Web Database Demo
