Security set up: Full Version Users

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

Guest

I have an Access Database that is used by up to 10 users simultaneously.
Until now, they have been using "run time" versions of access... and I have
had the only "full" version. This has worked well for keeping people out of
places in the database they really shouldn't be in. However, now the users
are getting new computers with full versions of access. My concern here is
this: How do I keep them out of the tables and background stuff? We will be
getting a new system in a few months... this database is the only thing we
have until then. I really can't risk loosing the data b/c someone decided to
play around in the new screens they have access to.

Any help would be greatly appreciated.
Desperate.

Thanks.
 
Thank you for your prompt response! I guess my biggest problem is that when I
open access in "full version", I can, on the Windows Task Bar, see that there
are a few different "tabs" I could click on in Access (besides the screen
that is currently open). ie: Switchboard, Table, Database Properties etc...
This is a little hard to explain without knowing the right lingo. If there
was a way I could keep people from knowing these screens were at their
disposal, I think it would be sufficient.

Any ideas?
 
BARKAROO said:
Thank you for your prompt response! I guess my biggest problem is that
when I
open access in "full version", I can, on the Windows Task Bar, see that
there
are a few different "tabs" I could click on in Access (besides the screen
that is currently open). ie: Switchboard, Table, Database Properties
etc...
This is a little hard to explain without knowing the right lingo. If
there
was a way I could keep people from knowing these screens were at their
disposal, I think it would be sufficient.
Click to expand...

Try hiding an object when it calls another, for instance, if Form 1 has a
button that opens Form 2 then have it also hide Form 1. You would then
unhide Form 1 in Form 2's Close event.

HTH - Keith.
www.keithwilby.com
 
Tools, Options, View tab - uncheck Windows in Taskbar. As for locking down
the database without using security, there are a number of things you can
do:

Backup your database; you can easily lock yourself out playing around with
these features.

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.
 
Back
Top