AccessRuntime

I am distributing an Access XP application using Access Runtime. If the user has no version of access, or uses '97 or earlier, there is no problem. However, if the user has Access 2000 on the local machine, that version starts and send an error indicating that the format is not recognized.

Is there a way to assure that my application starts only with Access Runtime, and not the user's full access system?

I had the idea that I could change the file extension and use windows to start Access runtime with my extensions, but I can't find the program that initiates Access Runtime.

Any help?:confused

You need to give your users a custom shortcut that points to the location [version] of Access you are using and also use the runtime command line option. Like this...

"C:\Program Files\Microsoft Office\Office\msaccess.exe" /runtime "C:\Databases\YourFileNameHere.mdb"

Here is how to do it for a secured db & runtime...

"C:\Program Files\Microsoft Office\Office\msaccess.exe" /runtime /wrkgrp "C:\Databases\SecuredWorkgroupFileHere.mdw" "C:\Databases\YourFileNameHere.mdb" /user UserNameHere

HTH