App Security

[BillyRogers]

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

 

[Alex Dybenko]

Hi,
you can make MDE - then all your forms/reports/VBA design changes will be
read-only (actually - no access to design)

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

 

[Keith Wilby]

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?

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