Permissions for MSysTables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I create a form the dynamically modifies the qry that is used as the source
of a report and then is used to preview the report.

When I use the form all is well. However, when a user (non admin) tries to
use it return an error stating that they don't have the necessary permission
the use the MSysTables??!

Can someone help please,

Daniel
 
Daniel said:
Hello,

I create a form the dynamically modifies the qry that is used as the
source of a report and then is used to preview the report.

When I use the form all is well. However, when a user (non admin)
tries to use it return an error stating that they don't have the
necessary permission the use the MSysTables??!
Click to expand...

By 'dynamically modifes the qry' do you mean you change the querydef
property in code? If so, users need modify permission on the query.
 
Thanks Joan, that was the Prob!


Joan Wild said:
By 'dynamically modifes the qry' do you mean you change the querydef
property in code? If so, users need modify permission on the query.
Click to expand...
 
Back
Top