system object

[iccsi]

I would like to have my table as system object and hide to the users.

I named the tables as MSystblMytable, but it always shows when I click
on the table on the databases windows.

Am I missing anything here to name a system object and hide from
users?



Your help is great appreciated,

 

[Tom van Stiphout]

On Wed, 9 Sep 2009 05:51:10 -0700 (PDT), iccsi <[email protected]>
wrote:

You didn't say which version of Access you are using. In recent
versions there is a Hidden checkbox among the Table Properties. No
need to name it MSys*.
You should also hide the Navigation Window, and provide your own way
for users to navigate the application.

-Tom.
Microsoft Access MVP

 

[Keith Wilby]

I would like to have my table as system object and hide to the users.

I named the tables as MSystblMytable, but it always shows when I click
on the table on the databases windows.

Am I missing anything here to name a system object and hide from
users?



Your help is great appreciated,

The usual method of protecting your tables is to hide the db window entirely
and have your users use forms.

Keith.
www.keithwilby.co.uk

 

[Douglas J. Steele]

While others have given you advice on how to handle your requirement, the
reason why your attempt failed is that you need to have the name start with
USys (as opposed to MSys).

 

[inungh]

While others have given you advice on how to handle your requirement, the
reason why your attempt failed is that you need to have the name start with
USys (as opposed to MSys).

--
Doug Steele, Microsoft Access MVPhttp://I.Am/DougSteele
(no e-mails, please!)









- Show quoted text -

Thanks millions for helping,