Macro blocks distributed DB

S

sam goforth

I have developed a DB on a machine running VISTA SP1 and Access 2007. I have
used the MS Developer Extensions to package that DB for distribution. When
distributed it fails to run.

AccessRunTime 2007 has been downloaded and installed on an object machine
running Windows XP SP2. I installed the DB distribution package on the object
machine. The DB execution stops immediately at the Autoexec macro and closes
when the error is acknowledged.

A similar reaction occurs on the development machine if the program location
is not added to the Trusted Locations, but it runs properly if the DB
location is trusted. Also, the option to run the macro and continue is
offered on the development machine but not on the machine with Windows XP.

I have used regedit to add the DB location as trusted on the XP machine in
the following branch:
HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Access\Security\Trusted
Locations\Location0 I am confident the registry entry is correct but the BD
will still not run.

Any help would be greatly appreciated.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top