Converting to Acc07 from Acc03

[dawnecia]

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

 

[Douglas J. Steele]

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.

 

[dawnecia]

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

 

[Douglas J. Steele]

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

 

[dawnecia]

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

 

[Jeff Conrad [MSFT]]

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

 

[AccessVandal via AccessMonster.com]

It's on the Ribbon tab Database Tools under the Ribbon called Administer. You
should see also the Replication Option there.

If you don't see it, it is not a MDB format database.

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

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

[quoted text clipped - 14 lines]

 

[dawnecia]

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]]

in message:

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