App Security

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to deploy an Access 2000 Database to another department in my compay
that utilizes linked views with SQL Server 2000. I need to hide the database
window and VBE. Basically prevent them from doing anything except using the
form.

I don't want them to be able to hit F11, hold the shift key or press Alt+F11
to get into anything other than the form they need to use.

Is there anyway to do this or do I need to get Visual Studio?
--
Billy Rogers

Dallas,TX

Currently Using Office 2000
 
BillyRogers said:
I need to deploy an Access 2000 Database to another department in my compay
that utilizes linked views with SQL Server 2000. I need to hide the
database
window and VBE. Basically prevent them from doing anything except using
the
form.

I don't want them to be able to hit F11, hold the shift key or press
Alt+F11
to get into anything other than the form they need to use.

Is there anyway to do this or do I need to get Visual Studio?
Click to expand...

Hi Billy.

Short of invoking user-level security I would say you need to set the
startup properties such that the db window is hidden, built-in menus and the
F11 key are disabled. Provide your own custom menus and disable the bypass
(shift) key
(http://msdn.microsoft.com/library/d...aac11/html/acproAllowBypassKey_HV05186992.asp).
A further measure would be to convert the mdb into an mde file so that the
code is compiled and removed.

HTH - Keith.
www.keithwilby.com
 
Back
Top