user-specific table restriction

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

Guest

Hello,

I have created a secured database. I also have created a form that restricts
users to seeing only the records that they entered (the username they use to
log-in to the database appears on each record). Now, I need to restrict the
table so that each user can only see the table records that they entered in
the form. In other words, they should see the same restricted data whether
they are in the form or the underlying table.

Is this possible?
If so, any help would be appreciated!
If it would help I can post the code I used to restrict the form.
 
Hi, Nicolle.
I have created a secured database.
Now, I need to restrict the
table so that each user can only see the table records that they entered
Click to expand...

If your users can open the tables and view records that should be
restricted, then your database is _not_ secure. Remove all permissions from
the tables for these users, then create queries based upon these tables, and
assign "Run With Owner Permissions" (RWOP). Use these queries as record
sources for the forms and reports. This way, you'll be able to easily
restrict which records and which fields are displayed for each user in the
forms and reports, but the users won't be able to open the tables and see
the data that they shouldn't.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
 
Back
Top