Windows Forum

Ask something
Discussion Locked

security in Access

0 helpful
1 reply

by jnorton

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
After setting up security in Access on one specific database I am being prompted to supply a password for all other databases on my desktop. Is there anyway to remove this security from my other databases. When I try to reverse what I intially did Iam getting VB warnings.

1 reply

by bobho

Did you create the security settings on your default workgroup file? If so, then that will apply to any database file you try to open. To set security for individual database files you will need to create individual security files and then use the Workgroup Administrator to change workgroups for the various database files.

Look at Access's help regarding creating mdw files and using the Workgroup Administrator.

DrBob:>)

This discussion is closed to new replies.