I have a report that uses a pass through query as record source.
When i open this report as an admin, it works fine without any errors. When i open the report as a user, it gives the Error 3033, You do not have permission to use msystables (attached file - i realized i cnnot attach files, sorry).
When i run the pass through query it works fine as both - the user and as admin.
Further, when i run a query in access "SELECT * FROM msystables", it says msystables does not exist. (But the report works fine as an admin).
All your help will be appreciated.
Thank You!!
When i open this report as an admin, it works fine without any errors. When i open the report as a user, it gives the Error 3033, You do not have permission to use msystables (attached file - i realized i cnnot attach files, sorry).
When i run the pass through query it works fine as both - the user and as admin.
Further, when i run a query in access "SELECT * FROM msystables", it says msystables does not exist. (But the report works fine as an admin).
All your help will be appreciated.
Thank You!!
