Prevent Database

  • Thread starter Thread starter Chris
  • Start date Start date
C

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.
 
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.
Click to expand...

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

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