Creating a Runtime version in Access 2010
Posted on 2011-04-27
I have an older Access database that I have upgraded to Access 2010 (.accdb format). I am trying to create a runtime version of this database so that users who don't have Access installed on their workstations can open the database and run queries and reports, but of course not enter new data. This is a VERY simple database - just a few tables, a few queries and one report. I've done this before with some other databases, but this one for some reason isn't working.
I'm using the Package Wizard from the Access 2010 application. Creating the package appears to work fine, and so does the installation process. But when I try to open the database, all I get is the Files tab - no Home tab and therefore no contents in the database at all. The Home tab appears briefly with a message about trusting the contents of the database, but when I click OK to open the DB, the Home tab disappears. Is there some security or permissions setting that I'm missing? The .accdr file is being saved to the user's My Documents folder, so they have full control of that location.