Results 1 to 6 of 6
  1. #1
    Join Date
    May 2019
    Posts
    10

    Multi user access to accdb file

    Evening All

    Apologies for the noobie question here, but I would like to know if an Access database (Office 365) can be accessed by multiple users simultaenously? I've written some code in VBA (AutoCAD) that opens an accdb file, records some data from a user (drawing issue information) then closes. Previously, this accdb file was stored in a shared dropbox folder, and although it works just fine for each user, becuase of the nature of syncing the file on each PC, occassionally we get 'conflicted copies' of the accdb file when multiple users access the file at the same time and it resyncs back to the central location then down to all other PC's.

    I did code a lame error trap to check for the lock file (.laccdb) and stops the database being opened by somebody else when it's present, but again, because of the nature of Dropbox syncing up and down, this trap is not foolproof.

    So now I'm working on keeping the database in a central cloud based location, so only one live copy in existance and no syncing. So, back to the beginning, can multiple user access and record data in the database at the same time?????




    Thanks very much in advance for and and all input.

    Graham

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Sure, lots of info here and in the related links:

    http://allenbrowne.com/ser-01.html

    To my knowledge having the file in a dropbox type location is problematic, as you've seen. I don't have any experience with "a central cloud based location" so can't comment on that.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    Join Date
    May 2019
    Posts
    10
    Thanks very much! I'll read that properly with fresh eyes in the morning.

    Hoping that a central cloud location will work in exactly the same way as a standard network server, although that may noe be the case because of login / access rights. Time will tell!

  4. #4
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    Just to confirm, Access works well on a wired local network. However it is problematic on any other network such as Dropbox, OneDrive, Google Drive or if using Wi-Fi.
    Any interruption to network connection can lead to data corruption.

    Using SQL Server gives greater resilience to network interruptions.
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  5. #5
    Join Date
    May 2019
    Posts
    10
    Thanks for the input. I don't know much about SQL other than the code I had to learn in order to let VBA push and pull data in and out of the Access database. Probably a stupid question, but do you know where I can find more noobie info on SQL? I'm only using Access because I have it with my 365 subscription.

    Cheers

  6. #6
    orange's Avatar
    orange is online now Moderator
    Windows 10 Access 2016
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Access 2007 won't open ACCDB file
    By Paul H in forum Access
    Replies: 12
    Last Post: 03-29-2016, 08:08 AM
  2. Replies: 2
    Last Post: 05-01-2014, 01:31 PM
  3. Replies: 10
    Last Post: 11-01-2013, 01:20 PM
  4. Replies: 11
    Last Post: 07-17-2011, 08:56 PM
  5. Multi-User Access
    By alyon in forum Access
    Replies: 4
    Last Post: 07-13-2011, 11:02 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums