I have a secure database setup which produces a report that is the result of data taken from a table which is created using a make table query. Each time the query is run the database is recreated. The user of the report is given permission for all related tables, but when she prints the report the first time, the table is recreated and the next time she attempts to print the report she no longer has permission to use that table. Is there any way to get around this problem?
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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Security & Make Table Queries 1
- Thread starter barbshop
- Start date
-
1
- #2
dannyocean
Technical User
Go into security/ USer groups and permissions, make sure that she has rights assigned to a new table. This is the first entry in the object name box when the object type is table.
HTH
Danny
HTH
Danny
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question