User restrictions?

K

KurtJD

I am operating on MS Access 2002 and need to restrict the users interfacing
with the program from the backend as well as the table/query/form/etc. combo
box that opens when the program is opened. Basically, I want to limit the
user to the front end and restrict them from changing anything in the db.
Thanks!
 
M

Maurice

i don't get it completely but you could set the file to read only maybe?

Do I understand correct that you don't want to the users to edit/add any
data into the db?
 
K

KurtJD

Not quite. When I open the program, 2 things open. The interface from the
program, and the standard box where you create tables, forms, queries,
reports, etc. This is the box I want to protect. I don't want the user to be
able to change the program (i.e. tables, queries, forms) but they still have
to interact with the program.
 
T

tedmi

Quick-and-dirty way:
A2007: Office button, Access Options, Current Database; in Application
Options, set the form you want displayed on open; in the Navigation section,
turn off Display Navigation Pane.

Previous versions: Tools>Startup, turn off Display Database Window

More robust way:
Convert the front end to a MDE
 
M

Maurice

Ted is right, in that case create an MDE which is the safest. In 2007 goto
database tools ribbon and choose create accde. In 2003 goto tools database
utilities - make mde.

hth
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top