Hiding queries Access 2000/2003

[vbajock]

Ok, I know how to hide tables programmatically, how do you do the same with queries? I've look all over the web and can't find anything that says how to do it.

 

[fneily]

Actually, the user shouldn't see any of the objects except forms. Have you looked at Tools - Startup and uncheck Display Database Window. Select a form to display when the database is opened. The options won't take effect until after you close the database and then reopen.
One way: If you put Usys in front of an object's name, such as UsystblCustomers or UsysQueryName, it'll hide it. You would then go to Tools - Options and check System Objects to see them. Of course, your forms and reports have to refer to the name with Usys.

 

[vbajock]

I said "programmatically".

There is no way to do it, as far as I can see. My solution was to hide the entire database window from the user and populate a form with reports for the user to select.

 

[MajP]

I said "programmatically".
There is no way to do it, as far as I can see.

Really?

Application.SetHiddenAttribute acQuery, "yourQuery", True

 

[vbajock]

I tried that, but the problem I ran into was in logging into databases that had workgroup security enabled - there are no parameters in the Application object for passing the username/pwd, it kept popping the password box and I couldn't find away around it. A solution to that problem would also help me with some other stuff as well.