I have 3 payroll tables with 3 security requirements, say, TableHourly, TableAcct, TableExec. These table definitions are identical. However, only 5 people should be able to read TableAcct and only 2 should be able to read TableExec. Anyone can read TableHourly. The access is based on the operator's login ID. When the application opens, the system sets the access type. Depending on the category, the forms' RecordSource should be one of the three tables. Since there are a number of forms involved, I would prefer not changing the form's RecordSource in each form. I would like all the forms to refer to, say, PayTable. However, when the application opens, I want PayTable to be dynamically linked to TableHourly, TableAcct, or TableExec. I want to set the access limitations within SQL Server so that no one can directly link to an unauthorized table and read it. Any suggestions? Eddie