Re: want to be done with workgroup files and user level security

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Thanks Rick. Do I also need to tell Access not to seek out the workgroup
information file?

One other complication that I forgot to mention is that I have other 2003
database that I am not updating to 2007. Will I also need to grant full
permissions to the Users group for these databases?

Thanks!

"Rick Brandt" wrote:

AccessMan wrote:
I have a 2003 database that uses a workgroup information file and
user-level security. I'd like to be rid of both, and I've read that
updating to 2007 format (.accdb) will take care of that. I did try a
Save As to 2007, but I was still prompted for a login password via
the workgroup information file when I tried to open the database. Is
there more required for me to do to get rid of the cumbersome
workgroup file and ULS?

Thanks!

Open Access using your secure workgroup and log in as someone with
administrative permissions, then open your file.

Grant FULL permissions to the default group 'Users' to the database object and
all other objects.

Now the file should be able to be opened with any workgroup file.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com




.

Relevant Pages

  • Re: Remove Password
    ... "Rick B" wrote: ... This assumes that he created a new workgroup before playing around ... so secure no one could get in!! ... Adding userid's and passwords to a workgroup does not secure a database ...
    (microsoft.public.access.security)
  • Re: Locked out of dbase ATTN: RICK
    ... Rick, you rock! ... I deleted the mdws like you suggested, then opened the database (while ... Doing so is the only sure way to secure ... >>> would creating the new workgroup automatically give me administrative ...
    (microsoft.public.access.security)
  • Re: Locked out
    ... Rick B: a thousand kisses and a big bouquet of roses. ... > You will either need to enter the password, or recreate your workgroup file. ... >> provide any username and password. ... Please help as I cant open any database on my ...
    (microsoft.public.access.security)
  • Re: Locked out of dbase
    ... "Rick B" wrote: ... it does not sound like your database is properly secured. ... All you have done is added passwords to the workgroup you are ... >>> Confirm that you are asked for a USERID and a PASSWORD. ...
    (microsoft.public.access.security)
  • Re: Access97 conversion permission issue with Access2003
    ... "Use the Workgroup Administrator program to create a new ... ID strings that you will be prompted for when you create your new workgroup ... information file and store them in a safe place. ... is for upgrading a secured Access database to a newer version of Access. ...
    (microsoft.public.access.security)