Protecting Microsoft tables

  • Thread starter Thread starter brimil
  • Start date Start date
B

brimil

This should be an easy one....How do i Protect the tables
so the user of the file can only view the forms (w/o
minimizing them)that I have built....
 
brimil said:
This should be an easy one....How do i Protect the tables
so the user of the file can only view the forms (w/o
minimizing them)that I have built....
Click to expand...

Check your help files for sample code for AllowByPassKey. Also check the
following on the Access Web:

http://www.mvps.org/access/general/gen0040.htm

This will only hide the database window. To really protect your data, use
user-level security, split the database into front and back ends, and allow
no permissions on the data except through a special WITHOWNERACCESSOPTION
Have a look at the Access Security FAQ for instructions:

http://support.microsoft.com/support/access/content/secfaq.asp
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
-----Original Message-----


Check your help files for sample code for AllowByPassKey. Also check the
following on the Access Web:

http://www.mvps.org/access/general/gen0040.htm

This will only hide the database window. To really protect your data, use
user-level security, split the database into front and back ends, and allow
no permissions on the data except through a special WITHOWNERACCESSOPTION
Have a look at the Access Security FAQ for instructions:

http://support.microsoft.com/support/access/content/secfaq ..asp
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.530 / Virus Database: 325 - Release Date: 10/22/2003


.
OK....I think then what I need to do is to open the file
Click to expand...
up so that the switchboard and all the forms are available
to the user and then be able to create a way to block the
user from seeing any of the macro, table, form, query
views.......any suggestions there?
 
brimil said:
OK....I think then what I need to do is to open the file
up so that the switchboard and all the forms are available
to the user and then be able to create a way to block the
user from seeing any of the macro, table, form, query
views.......any suggestions there?
Click to expand...

You can do a number of things to keep the idle curious out, however it won't
block the determined.

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

Create custom menus/toolbars for use throughout your application.
Use the features in Tools, Startup to
set the startup form (your switchboard)
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)

As Arvin said, you should disable the shiftkey bypass, or your users can
bypass all the settings in Tools, Startup.

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