I have a problem where tables are created with a make table query. Occasionally, we run into an error where the user (and myself) are denied permission to delete the table (it is deleted and remade many times a day) before the new one is created. How can I assign (or unassign) permissions on a table manually created this way?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
User Permissions on a Make Table Query
- Thread starter RoseV
- Start date
I have had this problem many times, since we have a Database with about 30 Users aceessing info at the same time.
For a Table that is being deleted and recreated on a continuous basis. Make that the table should be created in the each one PC's Local temp directory. Let your SQL reflect where it should create the table and you will never have problems with a conflict.
For a Table that is being deleted and recreated on a continuous basis. Make that the table should be created in the each one PC's Local temp directory. Let your SQL reflect where it should create the table and you will never have problems with a conflict.
- Status
Similar threads
- Locked
- Helpful tip
- Locked
- Question
- Locked
- Question