How do you create users and groups in Access 2007?

[blueskies]

Hi All,

Can someone please advise how to create users and user groups in Access 2007. In 2003 it was simple and straight forward, and at the risk of sounding stupid I can't find the same interface in ver.2007.

Any help will be appreciated.

[missinglinq]

There's a very good reason for that, it doesn't exist! From Allen Browne's comprehensive site:

ACCDBs do not support security, and Access 2007 does not provide the interface to manage security for MDBs. Use tables attached to a database that has security (SQL Server, MySQL, ...), or attach tables from an MDB and manage them as described in kb 918583

http://support.microsoft.com/kb/918583

or Security Considerations and Guidance for Access 2007

http://msdn.microsoft.com/en-us/library/bb421308.aspx

or What happened to User-Level Security?

http://office.microsoft.com/en-us/access/HA102345611033.aspx

(In reality, the Access security was never more than a padlock.)

Welcome to Bytes!

Linq ;0)>

[hjozinovic]

Hi All,

Can someone please advise how to create users and user groups in Access 2007. In 2003 it was simple and straight forward, and at the risk of sounding stupid I can't find the same interface in ver.2007.

Any help will be appreciated.

Anywhere in Immediate window (CTRL+G in VBA) type:

DoCmd.RunCommand acCmdWorkgroupAdministrator

and hit Enter. The interface will open just like in Acc2003.

[mshmyob]

AC2007 does not use user group security anymore. You need a Sharepoint server for security. Or you can create your own.

cheers,