473,548 Members | 2,593 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

How do you create users and groups in Access 2007?

1 New Member
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
3 9841
missinglinq
3,532 Recognized Expert Specialist
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
hjozinovic
167 New Member
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
904 Recognized Expert Contributor
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

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

Similar topics

27
45507
by: Wayne | last post by:
I've been clicking around Access 2007 Beta 2 and can't see the custom menu bar designer. Is it in the beta? Maybe I'm blind. The question that comes to mind is: Will custom menu bars be the same height as they were in previous versions or will they be the "ribbon" style that takes up a huge portion of the screen? Also when I use Access...
17
7648
by: Neil | last post by:
A client of mine likes some of the new bells and whistles in Access 2007, and is thinking about converting our A03 format MDB to an A07 format file. However, while some of the users have A07, many do not, and it's not clear when they would get it. His thought was to use the upcoming Access 2007 runtime to allow the users who are still running...
16
11048
by: Neil | last post by:
I posted a few days ago that it seems to me that the Access 2007 rich text feature does not support: a) full text justification; b) programmatic manipulation. I was hoping that someone might know one way or the other whether that was true or not, or could point me to an article or help text that would. What I have seen so far online and in...
10
555
by: Lou O | last post by:
I have been using Access 2007 for a number of months and have successfully deployed ACCDR files on many client machines. The client machines have the "free" Access runtime version installed. I recently installed SP1 for Office 2007 on my computer. Now when I make an ACCDE file to distribute, I get an error on client machines something like...
5
3006
by: WPW07 | last post by:
Hello, We have several complex applications developed in Access 2003 by various outside consultants. These applications link to a variety of Oracle tables and are used only for Access reports. User level security is also built in via the mdw workgroup file for all applications. I've been asked to research how viable it is to convert...
4
3018
by: hausj0dw | last post by:
How can I rermove the sort option on columns displayed on a form. This database is access 2003, some users have access 2007. The 2007 users want the sort option removed.
1
1474
by: Sport Girl | last post by:
Hello everybody, i hope that you are doing well. Please can anybody help me with this task, it is urgent: does anybody know how to grant access privileges to tables to users in Access 2007. idon't have any idea. Best Regards.
0
2026
by: ncsthbell | last post by:
I have a request to programatically create a .pdf file from within a current access application. The problem is that they want this one .pdf file to contain both an access report (created by the application) and a word document that resides in a folder outside of the application. I currently create some .pdfs for other access reports but I have...
7
15337
by: sweetfalguni | last post by:
hello, I want to create 2or 3 users in Msaccess 2007 inwhich first user say namely 'Administrator' has rights to access or edit or delete or modify table,forms,reports. Second user say namely' Userq' has rights to access only forms where he add records n not able to read or edit or delete table' And also the file is store in...
0
7707
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
1
7466
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
6036
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
0
5082
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3495
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
0
3475
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
1926
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
1
1051
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
751
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.