I am having a problem running Access 2007 runtime on a workstation. I have set up the 2007 database (.accdb) on our server and am able to connect to it and open it from the pc that has Access 2007 full version installed and it works fine.
I also installed Access 2007 runtime on another PC and was able to open the database using the runtime version just fine.
However, on this other PC, I installed the runtime version, and when I use the command line (msaccess.exe /runtime \\server\directory\database.accdb) to open the database in runtime mode, Access opens for a split second and then closes immediately.
I also tried copying the database to this machine and running it with the runtime version locally, but it still did the same thing.
When I just run msaccess.exe, it opens the runtime version and says that I have not specified a database, as expected. So, I am wondering why it is not opening the database when i DO specifiy the database.
If i specify an incorrect directory for the database, it opens the runtime version and a dialog appears telling me that a database was not found, and upon clicking OK, the program closes.
Additionally, I tried using a copy of the sample Northwind Database. I got the same result when trying to open this database with the runtime version…meaning it has nothing to do with my particular database, but it is a setting with Runtime or some Windows setting that I am unaware of…
I can’t seem to figure this out, and any help is appreciated.