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!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Change Run permission for queries by code

Status
Not open for further replies.
hayo

hayo

MIS
Sep 14, 2001
56
DE
In my access97 app, the run property for all queries is set to "Owners".

Now I want to upgrade the secured mdb-file to access 2002. For this purpose, I have to unsecure the mdb first. And in this context I read, that I should change all run permissions on queries to "users".

How can I set this property to "Users" programmatically ?

Otherwise, I have to do that for each single query, and there are very much of them ...

Thanks for your hints

Hayo
 
Status
Not open for further replies.

Similar threads

Moss100
  • Question
Open filtered for and set cursor at particular record
Replies
1
Views
130
Moss100
Moss100
Moss100
  • Locked
  • Question
Code not working 1
Replies
5
Views
149
Darrylles
Darrylles
renigar
  • Locked
  • Question
Code to write file path to field always writes to 1st record 1
Replies
5
Views
250
dhookom
dhookom
AJAY0618
  • Locked
  • Question
How to pass a variable in VBA code by opening a form and storing the variable
Replies
3
Views
147
AJAY0618
AJAY0618
ziffer68
  • Locked
  • Question
Pass Through query to create an alias for DB2 member
Replies
0
Views
313
ziffer68
ziffer68

Part and Inventory Search

Sponsor

Back
Top