Is it possible to prevent users from running individual queries but allow macros to run them? I have some that I only want to run as part of a macro in a certain order.
Novice
Windows 8 
Access 2010 64bit
Is it possible to prevent users from running individual queries but allow macros to run them? I have some that I only want to run as part of a macro in a certain order.
VIP
Windows XP Access 2007
One way would be to convert your queries to SQL code (just change to SQL View on your query, and Copy and Paste the code). You can then imbed that SQL code in VBA and run that SQL code in VBA instead. Then the users wouldn't even those Query objects in Access.
VIP
Windows 7 64bit Access 2010 32bit
JoeM is correct. But it also sounds like maybe you have an issue in terms of having the navigation pane available to users in general......
Access DB Lock Out
Posting Permissions
Reply With Quote