microsoft access training - Access Hide table in a splt database

Resolved · Low Priority · Version Standard

Fri 13 Apr 2007, 15:54 Delegate Paul said...

Paul has attended:
Access Advanced course

Access Hide table in a splt database

I have split thedatabase and I want to stop other users from seeing my table in a soure database, thus giving complete security from other users.

Tue 17 Apr 2007, 11:07 Trainer David said...

RE: Access Hide table in a split database

Hi Paul

I trust that you found your MS Access Advanced course useful.

Access does have a security feature within it that you might find useful. It will allow you to set up security and login's, so that you can control who sees what data.

To do within Microsoft Access go to Tools > security

Hope this helps
David

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Access tip:

Hiding Multiple Table columns

If you want to hide non-adjacent Access table columns. In Datasheet view, open the table that contains the columns you want to hide.

On the Format menu, click Unhide Columns.
In the Unhide Columns dialog box, clear the check box next to the name of each column you want to hide.
Click Close.

This method makes having to use the Hide Columns command repeatedly unnecessary

View all Access hints and tips