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?

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:

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


On Thu, 29 Jun 2006 11:34:02 -0700, yar
<y**@discussions.microsoft.com> wrote:

--
jackmacMACdon***@telusTELUS.net
remove uppercase letters for true email
http://www.geocities.com/jacksonmacd/ for info on MS Access security

yar wrote:
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.

Correct Sequence?
Windows UserID and Access
Problem with References
Import to bypass security
RE: ade to adp - utility available to help protect source code
Open Access from an Access program that is currently running
Security issues.
How do i publish database on a server?
workgroup information file & passwords
type mismatch when using security wizard