Blocking my employees view of tables.

[Guest]

How can I block the tables of my database so they can not be viewed by my
employees? What I am trying to accomplish is to let my employees work with
the forms of my database but not let them view the tables. The reason I would
like to do this is so if an employee were quiting they could not open the
table and print out a spreadsheet type view of our entire database. I would
like for them to only be able to work in the form view so if they were to try
to steal the daatabase it would take much more work by them having to print a
record by record copy to get all the information. Is this possible to do?

 

[Pieter Wijnen]

very simple trick is to include /runtime in the shortcut
create an Autokeys macro to "steal" F11
turn off 'use access special keys'

Pieter

 

[Guest]

I am very new to Access can you walk me through this process?

 

[Pieter Wijnen]

To create a shortcut

<Path to msaccess.exe> <path to mdb> /runtime

In AutoKeys (macro)

macro name: {F11}

for turning off all access hotkeys
Ctrl + g
type: application.setoption "'use access special keys'", False

Pieter

 

[Guest]

Wont my employee still be able to get to the Database Window by going into
the tools menu and going to startup?

 

[(PeteCresswell)]

Per BHostler:

How can I block the tables of my database so they can not be viewed by my
employees? What I am trying to accomplish is to let my employees work with
the forms of my database but not let them view the tables. The reason I would
like to do this is so if an employee were quiting they could not open the
table and print out a spreadsheet type view of our entire database.

You can play a few tricks to make it harder - but the only way I
know of to *really* control that kind of access is to move to SQL
Server or some equivalent - and my money is on your not wanting
to do that because of the time/expertise requirements.

 

[Pieter Wijnen]

Not with the /runtime switch
Also you can make your own Menu & Toolbar.
btw the option to set is Application.SetOption "AllowByPassKeys", False
There's no 100% foolproof way of keeping them away from the tables, but you
will send them a message not to by following these steps.

Pieter