Access Run-Time

[Guest]

I recently developed a rather extensive database for billing, client
tracking, etc., for use at my office. I now need to deploy this database to
select workstations within the office. I attempted to do this, using Access
2k3 with Developer Extensions. I set all user-level control to a minimum
(ie., limited menus, disabled shortcuts and special commands, etc.)
Unfortunately, when they first open the program they get a few messages about
the fact that potentially harmful code could be run if they allow the program
to open and must correctly respond to three separate prompts about blocking,
allowing, and opening the database. When I first got Access 2k3 I was able
to disable this in some menu or another, unfortunately, with limited menus
and no access to various options, I am unable to change these settings on the
packaged program with Access 2K3 runtime. How do I get around this, or
bypass these 'warnings'?

 

['69 Camaro]

Hi.

You can change the Windows Registry manually, or you can write VBA code to
open the Macro Security dialog window for the user to make the change
manually in the Access runtime application. An explanation of both methods,
including source code, in both English and Spanish, to access the built-in
menu, can be found here:

http://www.Access.QBuilt.com/html/vba.html#SetMacroSecLvl

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

 

[Jeff Conrad]

See:

http://www.access.qbuilt.com/html/vba.html#SetMacroSecLvl

 

[Sharat Koya]

You could optionally use a digital signature to sign your code. This would
negate the need to lower Security Settings.