My Acc03 databases are secured using workgroup (user level) security. I am
in the process of converting to Acc07. How do I after upgrading to Acc07 get
rid of the workgroup and still keep the databases secure?

Thanks

If you want user-level security, you cannot convert to the new .accdb format
in Access 2007: you need to leave your application in .mdb format.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"dawnecia" <(E-Mail Removed)> wrote in message
news:E5180951-62A9-45F0-B555-(E-Mail Removed)...
> My Acc03 databases are secured using workgroup (user level) security. I
> am
> in the process of converting to Acc07. How do I after upgrading to Acc07
> get
> rid of the workgroup and still keep the databases secure?
>
> Thanks

If I leave it as .mdb would I be able to add new groups and users?

"Douglas J. Steele" wrote:

> If you want user-level security, you cannot convert to the new .accdb format
> in Access 2007: you need to leave your application in .mdb format.
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no private e-mails, please)
>
>
> "dawnecia" <(E-Mail Removed)> wrote in message
> news:E5180951-62A9-45F0-B555-(E-Mail Removed)...
> > My Acc03 databases are secured using workgroup (user level) security. I
> > am
> > in the process of converting to Acc07. How do I after upgrading to Acc07
> > get
> > rid of the workgroup and still keep the databases secure?
> >
> > Thanks
>
>
>

Yes, although you'd need to do it through code, as I don't believe Access
2007 includes an interface to simplify it.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"dawnecia" <(E-Mail Removed)> wrote in message
news:2423DEF0-D327-4639-8E87-(E-Mail Removed)...
> If I leave it as .mdb would I be able to add new groups and users?
>
> "Douglas J. Steele" wrote:
>
>> If you want user-level security, you cannot convert to the new .accdb
>> format
>> in Access 2007: you need to leave your application in .mdb format.
>>
>> --
>> Doug Steele, Microsoft Access MVP
>> http://I.Am/DougSteele
>> (no private e-mails, please)
>>
>>
>> "dawnecia" <(E-Mail Removed)> wrote in message
>> news:E5180951-62A9-45F0-B555-(E-Mail Removed)...
>> > My Acc03 databases are secured using workgroup (user level) security.
>> > I
>> > am
>> > in the process of converting to Acc07. How do I after upgrading to
>> > Acc07
>> > get
>> > rid of the workgroup and still keep the databases secure?
>> >
>> > Thanks
>>
>>
>>

Do you know where I can kind the code to do this?

"Douglas J. Steele" wrote:

> Yes, although you'd need to do it through code, as I don't believe Access
> 2007 includes an interface to simplify it.
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no private e-mails, please)
>
>
> "dawnecia" <(E-Mail Removed)> wrote in message
> news:2423DEF0-D327-4639-8E87-(E-Mail Removed)...
> > If I leave it as .mdb would I be able to add new groups and users?
> >
> > "Douglas J. Steele" wrote:
> >
> >> If you want user-level security, you cannot convert to the new .accdb
> >> format
> >> in Access 2007: you need to leave your application in .mdb format.
> >>
> >> --
> >> Doug Steele, Microsoft Access MVP
> >> http://I.Am/DougSteele
> >> (no private e-mails, please)
> >>
> >>
> >> "dawnecia" <(E-Mail Removed)> wrote in message
> >> news:E5180951-62A9-45F0-B555-(E-Mail Removed)...
> >> > My Acc03 databases are secured using workgroup (user level) security.
> >> > I
> >> > am
> >> > in the process of converting to Acc07. How do I after upgrading to
> >> > Acc07
> >> > get
> >> > rid of the workgroup and still keep the databases secure?
> >> >
> >> > Thanks
> >>
> >>
> >>
>
>
>

See this page on my site for help on finding the security entry points when working with Access 2007
and MDB files:
http://accessjunkie.com/faq_17.aspx

--
Jeff Conrad - Access Junkie - MVP Alumnus
SDET II - Access Test Team - Microsoft Corporation

Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
http://www.accessmvp.com/JConrad/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com

----------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.mspx
----------

"dawnecia" wrote in message:
news:FCE48E09-2BE8-4BF8-B83F-(E-Mail Removed)...

> Do you know where I can kind the code to do this?

Jeff thanks. By the way I bought your book a few days ago (Access Inside
Out). I should get it next week.

"Jeff Conrad [MSFT]" wrote:

> See this page on my site for help on finding the security entry points when working with Access 2007
> and MDB files:
> http://accessjunkie.com/faq_17.aspx
>
> --
> Jeff Conrad - Access Junkie - MVP Alumnus
> SDET II - Access Test Team - Microsoft Corporation
>
> Co-author - Microsoft Office Access 2007 Inside Out
> Presenter - Microsoft Access 2007 Essentials
> http://www.accessmvp.com/JConrad/accessjunkie.html
> Access 2007 Info: http://www.AccessJunkie.com
>
> ----------
> This posting is provided "AS IS" with no warranties, and confers no rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.mspx
> ----------
>
> "dawnecia" wrote in message:
> news:FCE48E09-2BE8-4BF8-B83F-(E-Mail Removed)...
>
> > Do you know where I can kind the code to do this?
>
>
>

"dawnecia" wrote in message:
news:58BF7517-F802-43A8-B908-(E-Mail Removed)...

> Jeff thanks. By the way I bought your book a few days ago (Access Inside
> Out). I should get it next week.

I hope you enjoy the book!

--
Jeff Conrad - Access Junkie - MVP Alumnus
SDET II - Access Test Team - Microsoft Corporation

Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
http://www.accessmvp.com/JConrad/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com

----------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.mspx
----------