Password Protecting Tables

  • Thread starter Thread starter Erik
  • Start date Start date
E

Erik

Hi All!
Does anyone know of a way I can keep the database un-
protected, but have the user type a password to get into
certain tables in the database? I tried using user-level
permisions, but to force these users to a certain
workgroup file will not work (they have to have full
permissions on some databases, but not on all).
Any help would be greatly appreciated!
Thanks,
Erik
 
Hi Erik,

It is possible (indeed usual) to secure only one database, while keeping
others secure.

Keep the system.mdw workgroup as the default, and give each user a desktop
shortcut to launch the secure database using its secure mdw. The target
would look like
"path to msaccess.exe" "path to mdb" /wrkgrp "path to mdw"

It is also possible to secure a mdb, and have them use the default
system.mdw (no login). But this requires that you only have one group of
users.
 
Back
Top