Prevent Database

[Chris]

i want all the users can only access the data via the form
not directly the table and design view of table. what can
i do? is there any way the database (back end) can be
hidden? any good suggestion?
e.g. salesperson can make sales orders, but what if they
open the table and directly change data there!!!
Thanks for the answer.

 

[Jeremiah Ellison]

i want all the users can only access the data via the form
not directly the table and design view of table. what can
i do? is there any way the database (back end) can be
hidden? any good suggestion?
e.g. salesperson can make sales orders, but what if they
open the table and directly change data there!!!
Thanks for the answer.

You can hide the database window by clicking on the Tools menu and selecting Startup, uncheck the check box that says
"Display Database Window". This will not prevent the user from accessing the tables but it will make it more difficult. The
database window can still be displayed by clicking on the Database Window icon in the toolbar or by selecting the current
project in the File menu.

Jeremiah Ellison
Ellison Enterprises - Your One Stop IT Experts

 

[Dave Elliott]

Additionally you could also via Explorer or some other file manager hide the
Folder where your back ends resides.
Hope this helps. I assume you are using a custom menu or either startup form
on load.

You can hide the database window by clicking on the Tools menu and

selecting Startup, uncheck the check box that says

"Display Database Window". This will not prevent the user from accessing

the tables but it will make it more difficult. The

database window can still be displayed by clicking on the Database Window

icon in the toolbar or by selecting the current