Huckle said:
Keith,
Have you ever tried to open one database with another within the run-time
environment?
Thanks,
Huckle
You can certainly use the shell command to execute or launch a second
version of MS access in this case.
You cannot however use automation from the first version to launch a second
copy, or automate MS access .In fact you cannot do this even from visual
basic, windows scripting or any other environments that supports com object
automation.
The reason for this limitation is that when you are automate the runtime
version of MS access, you cannot provide MS access with a legitimate file
name. If you don't provide the runtime with legitimate file name, then the
application will not start.
However you are free to use the shell command or scripts to launch more than
one copy. So in theory you could certainly use the shell command and pass
the name of the file name that you wish to launch in this fahsion.
