I was finally able to create and join a workgroup. However, my concern is that when i join a new workgroup, the database that i thought i secured is no longer secure. Whatever users/passwords i had for the database no longer applies when i join a different workgroup. Is there a way to secure a particular database and not be asked for a username and password for a different database? If not, it seems that only one work group controls all the databases.
Well, i've done that. it works. however, when i open Access at msaccess.exe, I can easily open up the database i want to protect in administrator mode. The only way i see to fix this would be to be in my new workgroup rather than the default workgroup when i open Access, but then i think it would mean that i'd have to enter in all my usernames and passwords to open a database that i didn't want to protect.
Is there a way to get around this? Eventually the database will be placed on the server, and my concern is that a user may be able to retrieve the file and open it at administrator level. (At some point I'll switch to a SQL Server, but until then I'm using Access.)
Microsoft Access Security Manager Add-In Is Available in the Download Center
(235961) - The Microsoft Access 2000 Security Manager enables the database-security administrator to make knowledgeable security decisions as the database and its workgroup evolve. By presenting all security settings in a single view, the administrator can set...