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 concerns with a table resulting from a make-table query
- Thread starter barbshop
- Start date
- Thread starter
- #2
So hit me with something. As I thought about it, I couldn't recall exactly why I had made this query a make-table one. Obviously, I can use the query itself as input to the report, and not have to worry about permissions on the table.
Sorry for the bad question - althought if there actually is a way to do that, it would be interesting to know.
Sorry for the bad question - althought if there actually is a way to do that, it would be interesting to know.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question