MS Access 2003 Security

[Guest]

I have set up Security in MS Access database (one database) using a workgroup
and security set up. However, I could not limit the workgroup I created to be
limited to the Database I want to secure.

Every time I am using MS access (for any other database) it needs a longin

Could someone help me how to set up a work group for one database only?

 

[jacksonmacd]

Access security is applied to the *session*, not to the *database*.
You should rejoin the default workgroup file, and then create a new
shortcut to launch your secured database using its required workgroup
file. The syntax for the shortcut's target is:

"<fullPath to Access.exe>" "<fullpath to MDB>" /wrkgrp "<fullpath to
MDW>"

Access user security is not to be taken lightly, so read very
carefully and thoroughly, practice on a COPY of your database, and
don't skip any steps in the process.

Here are a number of links about security:

http://home.bendbroadband.com/conradsystems/accessjunkie/resources.html#Security

 

[hireagenius via AccessMonster.com]

I have set up Security in MS Access database (one database) using a workgroup
and security set up. However, I could not limit the workgroup I created to be
limited to the Database I want to secure.

Every time I am using MS access (for any other database) it needs a longin

Could someone help me how to set up a work group for one database only?

Hi
I use a shortcut on my desktop to open the secure database where the path
references the secure workgroup file.
The path in your shortcut should resemble this:
"C:\Program Files\Microsoft Office\Office11\MSACCESS.EXE" "H:\FolderName\
SecureDatabaseName.mdb" /wrkgrp "H:\FolderName\SecureWorkGroupFile.mdw"
With this method, you can use unsecure mdb's and not have to re-join the
unsecure workgroup file.

Hope this helps.
Charlie
Use the quotations, too.