In attempting to secure my database I have established the necessary users and groups. Can anyone recommend how I might be able to allow users when selecting a form to view only the rows that belong to them?
I gleaned and idea from a forum here to build a unique table for each user. The respective user would then be the only one given read write privileges to this table. Next, the query underlying my form is augmented with the table of an individual user. The join is such that only those records are retrieved belonging to the user? Is there a method by which I can vary this table according to the user's sign-on (for example if I have 10 users then ten individual user tables would be made with their foreign key linking to the larger more general table)?
The ultimate goal: Users sign on and open a form displaying their data only.
Thanks for any recommendations.
I gleaned and idea from a forum here to build a unique table for each user. The respective user would then be the only one given read write privileges to this table. Next, the query underlying my form is augmented with the table of an individual user. The join is such that only those records are retrieved belonging to the user? Is there a method by which I can vary this table according to the user's sign-on (for example if I have 10 users then ten individual user tables would be made with their foreign key linking to the larger more general table)?
The ultimate goal: Users sign on and open a form displaying their data only.
Thanks for any recommendations.