View Full Version : Table Security


Sharoon
01-02-2004, 05:07 AM
I'm Planning to create table holds my system's users information
It contains
UserID, UserName, PCName,PassWord

Is thee is a way to hide the table and make it visible only for Admin?

dcx693
01-02-2004, 06:42 AM
Consider implementing Access' built-in security. Worth the effort if you really want to protect your table data. Here's a faq: Microsoft Access Security FAQ Available in Download Center (http://support.microsoft.com/default.aspx?scid=kb;en-us;207793&Product=acc).

Oldsoftboss
01-08-2004, 02:27 AM
I think the only true way to protect a table is to use Access Security. Have tried it a couple of times and came unstuck big time. If you have never done this before, read, read, read or better still get someone with the knowhow to help.

Even hidden tables can be imported into another database, so Access Security may be the only way.

Oldsoftboss
01-08-2004, 02:29 AM
Something else... I would change the field Password to something else - like usrPassword or the like, as PassWord is a reserved word in access that may get confused.