We help IT Professionals succeed at work.

Creating a Runtime version in Access 2010

Hypercat (Deb)
on
Medium Priority
898 Views
Last Modified: 2012-06-22
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.
Comment
Watch Question

CERTIFIED EXPERT
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Scott McDaniel (EE MVE )Infotrakker Software
CERTIFIED EXPERT
Most Valuable Expert 2012
Top Expert 2014
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Hypercat (Deb)President
CERTIFIED EXPERT

Author

Commented:
OK - I thought I had done this with a database in the past that didn't have any form, but that was a while ago, and I may be mistaken. I'll give that a try.
Hypercat (Deb)President
CERTIFIED EXPERT

Author

Commented:
Creating the form worked perfectly - I discovered too that if you're not too picky about the way the form looks, creating a form from a table in Access 2010 is almost TOO easy!

The one problem I see is that the security warning message pops up every time they open the database. Anyone know of a way to prevent this? It's not too big a deal, just an annoyance because it appears every time.
CERTIFIED EXPERT

Commented:
Hi,

you can stop that by adding the folder where the database file is saved on the user's computer to the trusted locations. For this, open the Access options and there the trust center, there you can find the trusted locations where you can add any folder (and optional any subfolder of the selected folder) to the trusted locations. All Access files which are saved into this folder (or subfolder) will be executed without the security warning.

Cheers,

Christian
Hypercat (Deb)President
CERTIFIED EXPERT

Author

Commented:
Hi, Christian. Thanks for the response. The problem is that in the Access Runtime version, the user can't set the trusted locations from the application. I suppose it's probably a registry entry that I'll have to find and edit through a login script or something. I just thought someone might know this right off the bat and allow me to be lazy and skip the process of researching it myself ;-)
Hypercat (Deb)President
CERTIFIED EXPERT

Author

Commented:
Thanks guys!
CERTIFIED EXPERT

Commented:
Hi,

you can offer this option to the user with this command:

DoCmd.RunCommand acCmdOptions

Open in new window


This opens the Options dialog directly, you can use it in a button or menu. Problem with this is that it also opens other options to the user which you may not want the user to change it (for example timeout values for ODBC calls or whatever). I inserted this command in my applications in an admin menu only so only admins can change the options here.

Cheers,

Christian

Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.