Security Workgroup

[Davers]

I've been assigned to a Workgroup for a database, however, now every database I try to open, including my own, and including ones I created several years ago, all ask me for my User name and Password. Is this how it's supposed to work? If so...that's not good, on the database I've been assigned a workgroup for, I don't have complete read write priveledges, yet the ones I created...I need that. Does anyone know what's going on?

Thanks for any help...

Dave

 

[SydneyGeek]

There is some help for this on KnowledgeBase. Basically, you can belong to any number of workgroups, but only one can be active at a time.
One workaround is to re-join the default workgroup for the other databases, then join the special one when you want to open the other db. Kludgy.

These links may point you in the right direction:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;305542
And a step-by-step tutorial:
http://www.moretools.com/lessons/access_security.htm
Here is a code solution that will probably do the job:
http://accessvbsqladvisor.com/dMSAccess001.nsf/0/2c0d2cce318bb53e0ee00901e45474d6?OpenDocument

Denis

 

[Davers]

Thanks Denis, I'll check them out!

Have a good day,

Dave