User restrictions?

[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!

 

[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?

 

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

 

[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

 

[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