Discussion Locked

Access 2007 runtime opens then closes immediately

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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.

2 replies

by ohm.paul

I tried installing a 90 day trial of Access 2007 on the computer that was having trouble with the runtime version, and it is able to open the database just fine when using the normal program.

However, still when I add the /runtime parameter and directory of the database to the command, it still does the same thing. Access opens up for an instant and then closes immediately, with nothing showing in the access window for the instant that it is open.

At this point, I am completely stumped, I don't know how it could possibly fail with the full (trial) version installed. It's almost as if there is just something wrong with the PC's configuration and it has nothing to do with Access...but I really have no idea.

Any suggestions?

by ohm.paul

For anyone else that might have this problem...

After reinstalling all Office products on the computer multiple times, I resorted to Microsoft's guide to uninstalling Office 2007 completely.

http://support.microsoft.com/kb/928218

This involved deleting some hidden files and registry keys that are not removed when uninstalled via Control Panel. Finally, after doing this, I reinstalled Access Runtime 2007, and it worked as planned.

This discussion is closed to new replies.