Logging in to Access

[Guest]

Hi Everyone,

My problem is this:

I've created an access database (2003) on a shared drive for certain people
to use, but who have different levels of permission. However, after I've
created my own administrator using the security wizard, EVERYTIME and
EVERYWHERE I open an access database, it asks me for login information!!

I only want this ONE database to use logins and no others. How do I set this
up so that I can keep this database on a shared drive and have the system
only ask for login information when a user tries to open THAT particular
database?

 

[Rick B]

User IDs and Passwords are part of the Workgroup, not the databse.

If you joined a workgroup with userid's and passwords, then you will have to
sign into it regardless of which database you are opening.

What you should do is rejoin the default mdw file which does not contain
passwords and use that to open all your files. If you do that you should
NOT be able to open up your 'secured' database. If you can, then you have
discovered tha tthe file is NOT actually secured and you need to go back to
the drawing board. You should get an error if you try to open it with the
default mdw.

Once you have confirmed all that, you can create a shortcut to your secured
database that includes the workgroup file in the path. This would cause the
file to open and the appropriate workgroup to be used. BUT, any other file
that you open will use the default workgroup (unless you include a workgroup
in your shortcut for those other fiels).

 

[Rick B]

Here is a previous post that explains it well. Make sure to copy and paste
the entire link with no breaks...


http://groups-beta.google.com/group...rtcut+workgroup&rnum=1&hl=en#40c7b6f1adb3df06