Security

  • Thread starter Thread starter Amir
  • Start date Start date
A

Amir

Hi guys,
I'm trying to (finaly) distribute a access97 database and
I already got security (user level, and groups) done. What
I'm trying to do is make sure that users can't see
database window and open some tables...
I have tried using /runtime in shortcut I was getting a
error:" Can't find the dynamic-link library (DLL) Mso97rt."
I have tried copying a Mso97rt from my machine
(office97pro) to the machine in question (office97pro) and
still wouldn't work, on mine it works great...Not much
help from microsoft's website.. Also is there a better way
to lock up database so that you can't bypass it with
certain keystrokes.????
I would like to split the database before distributing
also... Any help to securing it more would me valuable
since this is HR database...
Thank you.
 
Amir said:
Hi guys,
I'm trying to (finaly) distribute a access97 database and
I already got security (user level, and groups) done. What
I'm trying to do is make sure that users can't see
database window and open some tables...
I have tried using /runtime in shortcut I was getting a
error:" Can't find the dynamic-link library (DLL) Mso97rt."
I have tried copying a Mso97rt from my machine
(office97pro) to the machine in question (office97pro) and
still wouldn't work, on mine it works great...
Click to expand...

The /Runtime switch only works on PCs that either have the Developer's
Version of Office installed (in which case it is largely for testing) or if
the PC actually has at least one Runtime application installed.
 
Create custom menus/toolbars for use throughout your application.
Create a startup form (a main menu form if you have one) that is opened on
startup.
Use the features in Tools, Startup to
set the startup form
set your default menu (the custom one you made)
disable all the checkboxes about allowing built in menus, toolbars,
changes etc.
hide the db window (ensure the custom menu you create does not
include the Windows, Unhide item
Click on the Advanced button and uncheck the allow special keys
(this will disable the F11 key, among others)

If you need to bypass these startup features, you can hold the shift key
down while you open the db. If you feel that your users may use this to
bypass your settings, you can disable the shift key bypass - there's an
example in help for doing this(look for AllowBypassKey) or at
http://www.mvps.org/access/modules/mdl0011.htm
and
http://www.mvps.org/access/general/gen0040.htm

You can also create a MDE from your database, which will prevent changes to
forms, reports and modules (If you do this, be certain to keep your original
mdb in case you need to make changes).

None of this will keep the determined out. All they need to do is start a
new db and link to your's, but this may suffice for your purposes.
 
Thank you guys for replying.
My only two questions are how come security is such a low
priority in Access (or in Microsoft for that matter).?? I
should be able to lock up my database without worrying if
someone is smart enough to just link up his database to
mine, and voila....
And is this security problem changed(addressed) in
OfficeXP and 2003.???
Thank you once again.
 
Actually, if you secure the backend, they shouldn't be able to just start a
new mdb and link to it. I shouldn't have included that sentence in this
case.
 
Back
Top