2007 Access runtime 1

[Domino2]

I have a database (.mdb) that I want to put on another pc to run. They do not have Access installed. I installed the 2007 runtime as 2003 no longer around. It works, however it will not open until the user acknowledges its safe. How does one get round the problem on a non 2007 pc? Thanks

 

[BradCollins]

you will need to add the database as a trusted location.

I use a small reg file to do this, just copy the code below to a notepad document and save it with a .reg extension

Windows Registry Editor Version 5.00
 
[HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Access\Security\Trusted Locations\Your Db Name]
"Description"="Your Db Name"
"Path"="C:\\dir1\\dir2"

once saved, run this file on any machine that you wish to use your database, this will set it permanantly as a trusted Db

 

[Domino2]

Many thanks Brad. So fust to confirm, the code you gave can be saved as any name providing it has a reg extension. If I add the db name as a straight name ie Best.MDB with no speech marks around it, and I just run it then that's it.
If that's the case then thats good, as I don't want to mess about with regedit or get in a mess with an IT department.

 

[BradCollins]

the code provided is typed (copied) into a notepad file, save the notepad file as filename.reg and have the users run that.
It will insert the details into the registry for you, without you having to go into reg edit.

After that you can just run your mdb/mde file as normal and you will not get the 'trusted location' message

 

[Domino2]

Many thanks, best regards