Permissions for MSysTables

[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

 

[Joan Wild]

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??!

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

 

[Daniel]

Thanks Joan, that was the Prob!

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

 

[Joan Wild]

Thanks Joan, that was the Prob!

You're welcome!