Workgroup Setup, Permissiions and Multi-user questions

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: John (anonymous_at_discussions.microsoft.com)
Date: 04/22/04 

Date: Thu, 22 Apr 2004 09:05:29 -0700

Hello,

I am working on a network file. I would like to set up
permissions for the approx. 5 users of the database.
What do I need to do? I know to right click properties
and select security and then I can add and remove users.
Where can I find out the definitions about the following:
full control, modify, read & execute, read, and write?
Basically, I maintain the database, create tables
structures and relations, queries, reports, and forms. I
want to access to everything, but I would like the data-
entry people to be only allowed to enter and/or modify
data thru the forms. My last question is about multiuser
capabilities of Access. I was under the impression that
this was possible due to record-locking when someone is
trying to modify a record which some one else is on at
the same time. Is that true, if so do I have to do
anything special or does the record locking protection
automatic?

I would greatly help with this.

Thanks

Relevant Pages

  • Re: Access Connection problem in aspx page
    ... Exception Details: System.Data.OleDb.OleDbException: The Microsoft Jet ... Access databse require read/write (Modify) permissions for the _folder_ ... containing the database file. ...
    (microsoft.public.inetserver.asp.db)
  • Re: Shared v. Exclusive Access
    ... Control Panel, Add/remove programs, find Adobe, click Modify -> create Adobe ... The folder wherein the frontend resides grants Full permissions to the ... When I open the database, however, I don't get the message boxes. ...
    (microsoft.public.access.security)
  • Re: What is wrong or missing if I cant modefy an exisiting workgroup?
    ... 1)I wasn't able to remove admins group form User Admin. ... database and managed to modify the existing newsystem.dmw. ... Allthough I found an application that had security ...
    (microsoft.public.access.security)
  • Re: Multiple users on an Access database
    ... I think version 97 was the last one that allowed you to modify objects while someone else was using the mdb - not any more. ... I've split the database however I'm still encountering problems. ... design of a Report or Form the following message appears " Microsoft ... Access can't save design changes or save to a new database object because ...
    (microsoft.public.access.security)
  • Re: Backend Ldb file
    ... the network rights are EXACTLY the problem. ... work as intended, all users should have Create, Modify, and Delete rights as ... If a user cannot create the LDB, ... > in the database on the previous day, but is not at work on ...
    (microsoft.public.access.setupconfig)