Secure tables in a database MS 2000

Dib · Dec 29, 2003

Hi,
How can I prevent a User from opening a table in MS Access 2000?

with out using or changing the security that comes with Access.

Thanks
Dib

Douglas J. Steele · Dec 29, 2003

Without applying Access security (as explained in
http://support.microsoft.com/support/access/content/secfaq.asp ), I don't
believe there is any way.

Dib · Dec 29, 2003

Thanks
Dib

Douglas J. Steele said:
Without applying Access security (as explained in
http://support.microsoft.com/support/access/content/secfaq.asp ), I don't
believe there is any way.

SteveD · Dec 29, 2003

A non-secure way, but it may work is some circumstances --
I set the property of the table to hidden. The routines
(queries, reports, etc) work, but the users can't see it
or connect to it .... UNLESS ... the have their Access
options set to view hidden objects. The settings are
found under Tools/Options and the View tab, where the
default it is NOT checked.

Give it a try

SteveD