What else I can do to secure the db?

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

Guest

I have to deploy a DB access xp to a stand alone machine and I want to add
the most security accions I can.

I have only the administrator user with a very long password
I have codified the DB
I have made the DB hidden

are those the only things I can do to protect the DB?
I feel like this is nothing, what else I can do?

any sug

kenny
 
Ken said:
I have to deploy a DB access xp to a stand alone machine and I want
to add the most security accions I can.

I have only the administrator user with a very long password
Click to expand...

Not sure what this means. Did you implement security in Access following
the FAQ?
http://support.microsoft.com/?id=207793
I have codified the DB
Click to expand...

I'm not clear what this means. Do you mean you created a MDE? That will
keep them from modifying/viewing the design of forms/reports/modules, but
not tables/queries/macros.
I have made the DB hidden
Click to expand...

Do you mean the database window, or the mdb file?
are those the only things I can do to protect the DB?
I feel like this is nothing, what else I can do?
Click to expand...

Some more ideas:

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

If you create a MDE, be certain to keep your original mdb in case you need
to make changes.

None of this will keep the determined out.
 
Back
Top