+ Post New Thread
Results 1 to 4 of 4
Group Project Thread, Access 2003 in Coding and Web Development; How do i enable my access database to have multi users being able to use it at the same time ...
  1. #1

    Join Date
    Feb 2008
    Posts
    79
    Thank Post
    1
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Access 2003

    How do i enable my access database to have multi users being able to use it at the same time without it being locked.

    As I have a database that a few people might be updating at the same time.

  2. #2

    SYNACK's Avatar
    Join Date
    Oct 2007
    Posts
    11,271
    Thank Post
    884
    Thanked 2,749 Times in 2,322 Posts
    Blog Entries
    11
    Rep Power
    785
    I think you just need to add in account support by going to Tools -> Security -> User level security wizard

    Users wont be able to modify the same value at the same time but it should allow multiple access.

  3. #3

    Join Date
    Mar 2007
    Posts
    307
    Thank Post
    3
    Thanked 9 Times in 8 Posts
    Rep Power
    17
    Split the database to have a seperate data file and a front end. Multiple users can access the database at the same time.

    Tools>database utilities>Database splitter.

  4. #4

    powdarrmonkey's Avatar
    Join Date
    Feb 2008
    Location
    Alcester, Warwickshire
    Posts
    4,867
    Thank Post
    412
    Thanked 778 Times in 651 Posts
    Rep Power
    182
    You should only not be able to get in if another user has the database open in exclusive mode (for changing forms, etc). In normal operation, access performs row-level locking, ie locks the actual row that you're changing, so that another user doesn't change the same data. Other rows and datasets are open to other users, regardless of user security levels, split databases, etc. That's the whole point of Jet.

    Exclusive mode is an option in the Open dialog. Normally it's non-exclusive.



SHARE:
+ Post New Thread

Similar Threads

  1. MS access 2003 security problem
    By rhyds in forum Windows
    Replies: 5
    Last Post: 16th January 2008, 05:26 PM
  2. Vista & MS Access 2003 Problem
    By ICTNUT in forum Windows Vista
    Replies: 6
    Last Post: 15th June 2007, 04:10 PM
  3. Exchange 2003 - Outlook Mobile Access
    By ajbritton in forum Windows
    Replies: 7
    Last Post: 20th December 2006, 06:11 PM
  4. Replies: 3
    Last Post: 10th March 2006, 02:54 PM
  5. Exchange 2003 web access problem
    By Rozzer in forum Windows
    Replies: 3
    Last Post: 18th January 2006, 11:09 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •