access queries for db maintenance 1

[dbpcar]

I have several databases that have multiple users. In each one are maintenance queries that I would like to hide. Is there a way to hide queries and/or reports within a database? I don't want all the users to be playing with them. Thanks

 

[jjonesal]

Right click on the object in the database window & choose properties. There's a hidden checkbox that you can select. Then if under Tools, Options you can specify not to show hidden objects... J. Jones
jjones@cybrtyme.com

 

[MichaelRed]

A better overall soloution might be to remove the queries from the User's databases. In general, Multiuser dbs should be split between the data and the remainder of the db. Including the "maintenance" queries to a seperate is just one additional step in that process.

MichaelRed
mred@att.net

There is never time to do it right but there is always time to do it over