On the fly run-time

[Question Boy]

I have been asked to do some work for a company and they are trying to stay
away from the IT department for various reasons. They have access databases,
but do not have access install on employee computers (only the IT dept. has
it). Instead they use some software that seems to deploy a run-time version
on the fly. Has anyone ever heard of such software as I have been unable to
identify it to learn more about it as my db behaves differently than when run
using access directly.

QB

 

[Tom Wickerath]

Hi QB,

I haven't heard of any such software, but you can simulate a run-time
environment to see what happens with your application, by clicking on Start |
Run, and entering:

msaccess "CompletePathToYourDatabase" /runtime

You can create a shortcut as well. If you have multiple versions of Access
installed, you'll need to provide the complete path to msaccess.exe, enclosed
in spaces (unless you are using the equivalent short names). Also, you'll
need to provide a switchboard form at startup (or customized ribbon, if using
A2007).


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

 

[Arvin Meyer [MVP]]

It might be possible but I really doubt it. The install of Access puts files
in several locations and writes to the registry. Since it writes to the
Windows and System32 directories as well as other restricted places, I'd
expect that elevated permissions would be required to install it.