By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,035 Members | 1,555 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,035 IT Pros & Developers. It's quick & easy.

How do you create users and groups in Access 2007?

P: 1
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.
Sep 23 '08 #1
Share this Question
Share on Google+
3 Replies


missinglinq
Expert 2.5K+
P: 3,532
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/ac...345611033.aspx

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

Welcome to Bytes!

Linq ;0)>
Sep 23 '08 #2

100+
P: 167
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:
Expand|Select|Wrap|Line Numbers
  1. DoCmd.RunCommand acCmdWorkgroupAdministrator
and hit Enter. The interface will open just like in Acc2003.
Sep 23 '08 #3

mshmyob
Expert 100+
P: 903
AC2007 does not use user group security anymore. You need a Sharepoint server for security. Or you can create your own.

cheers,
Sep 23 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.