Create users permissions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to create a user #1 that will only have access to
write data to 1 table via a form. This user should not
have access to any other object or the design of the
database. They also should not have the rights to
read/edit/delete any data in any table.

I have tried creating a user that only have read/write
permissions to the one form and table that they'd be
entering data through. I have then created and .mde file.
But I find that when the user SHIFT opens the database
they can open the actual table and edit the data there.

What can I do?
 
You can do all of this with so-called "user level security". Unfortunately,
it is quite a complex topic, with a steep learning curve, and many traps for
the unwary. If you want to take it on, start by reading the Access Security
FAQ: http://support.microsoft.com/?id=207793 Then read it another *50
gazillion times*, draw some diagrams, & spend a few weeks experimenting with
"throw-away" databases.

HTH,
TC
 
Back
Top