Hide Database Objects From Users

[Bill6868]

I've been developing a database that I am about to pass over to another office. I'd like to hide all the objests that make the database work - queries, forms, tables, macros. But I'd like the users to be able to write queries, save them and have them appear in the objects tab, but I don't want their queries to show up in the many queries I already have that run the database for fear that someone may accidently delete one.

I knew how to hide/unhide objects in the old Access 97 version, but in Access 2007 I am clueless, despite searching the help screens. I've found out how to hide an object (one at a time) under the database tools property sheet icon, but I have not figured out how to unhide it. Luckly while experimenting I am using a copy of the database.

Any advice would be most appreciated.

 

[Bill6868]

Good grief....I think I just answered my own question. On the "All Access Objects" tab, right click the title bar and choose "navigation options".

 

[Remou]

Some VBA.

Sub HideForms()
Dim frm
For Each frm In CurrentProject.AllForms
   SetHiddenAttribute acForm, frm.Name, False
Next
End Sub

Sub HideTables()
Dim tbl
For Each tbl In CurrentDb.TableDefs
    If Left(tbl.Name, 4) <> "MSys" Then
        SetHiddenAttribute acTable, tbl.Name, True
    End If
Next
End Sub

http://lessthandot.com