User restrictions?

  • Thread starter Thread starter KurtJD
  • Start date Start date
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!
 
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?
 
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.
 
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
 
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
 
Back
Top