Trust Centre

[aussie]

Hi, I have created a database and saved it to c:\Database\filename, using the full access 2007 version. I have made c:\Database a Trusted Centre.

I then copied the database onto my thumb drive (I:\Database\filename) and made this a trusted cenre.

I then added the Runtime version of Microsoft Access onto another computer.

When I try to access the database on the new computer I am unable to open the database, because it won't allow me to run macros.

When I try and open Access on the new computer, it won't open because it needs to associate to a database, so I am unable to set trust centers on the new computer.
Any help out there???

 

[Galaxiom]

A far preferable solution is to digitally sign the code. Then it will work anywhere once the user trusts the author. On a domain the whole process can be made completely transparent by using Group Policy to install the certificate in user's accounts.

However this option is not available for accd* files in 2007 format. Only packages can be signed. I only distribute mde so it is not an issue for me. There is nothing new worth having in the 2007 format anyway.

I understand the ability to sign a database was reintroduced in the accd* formats in Access 2010.

 

[Galaxiom]

You can make your own free certificate using certsvr on Windows Servers. Once the public key of this certificate is accepted by the user they will not be asked again about any of your certificates.

I recommend the signature because I see far too many people defeating the whole Trusted Locations setup by setting folders like My Documents as Trusted.

The table creation problem is an issue I have not considered.

 

[aussie]

Thanks all for your input. Will try out your suggestions