Hi again,

   As part of an application I am building, I want to hide all the tables, queries, forms, etc from the users. They are not sophisticated enough to know how to unhide them. Hiding them using the Properties dialog box works fine.

   However, one of the things the database does is, since it is OLAP only for these users, it deletes two existing tables On Open, and then takes new copies of the tables from a back end that is maintained with an administrative interface.

   This is the code I am using to copy the tables after the old ones are deleted:

'----------
DoCmd.TransferDatabase acImport, "Microsoft Access", _
        "I:\NFC_Data\Interfaces\AOC_WPM_POV_Authorized_be. mdb", acTable, "tblOrgCode", "tblOrgCode"
    DoCmd.TransferDatabase acImport, "Microsoft Access", _
        "I:\NFC_Data\Interfaces\AOC_WPM_POV_Authorized_be. mdb", acTable, "tblAuthorized", "tblAuthorized"
'----------

   I would like to add code to hide these tables once they are copied. I can hide them manually, but once they are deleted and a new version is brought over, they are not hidden since that attribute is not set in the transfer command.

Thanks in advance,


mmcdonal

__________________
mmcdonal

Look it up at: http://wrox.books24x7.com

Did u know that u can hide the entire database window from the end user by going to tools->startup, and then unchecking the "Display Database window" checkbox?

This means that only your startup form, if you have one, (and any subsequent forms, reports, etc, brought up programatically) will appear when you open the database. The user will NOT see any other tables, queries, forms, etc.

if you want to see the database window (which would come in hand when you want to modify anything)then simply press the shift key down when bringing up the mdb.

Thanks for your reply. I did hide the database window, but I think some of my users are sophisticated enough to know about the shift key, and also about f11 once in the database, to unhide the database window.

Once the database window is shown, there appear to be no objects in the database except the three tables transferred during the on open event of the main form. I want all objects to be hidden once the database window is shown.

I don't think my users are sophisticated enough to know how to unhide hidden and system objects once they have the window open, or that there would even be any hidden objects. They might think it is all code... which is why I am making an mde, to prevent them from seeing the path to the data.

Any other ideas?

Thanks again,


mmcdonal

Alright, i think this is pretty simple:

Application.SetHiddenAttribute acTable, "MyTable", True ' will hide the table "MyTable"

Application.SetHiddenAttribute acTable, "MyTable", False ' will unhide the table "MyTable"

Let me know if that is helpful

That's EXACTLY what I needed Developer1861!

You totally Wrox!

Thanks,


mmcdonal

de nada