Results 1 to 3 of 3
  1. #1
    WCStarks is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Sep 2016
    Posts
    314

    How to share an access db data over a network

    I am considering splitting the current local database and moving the back-end (tables) to a shared network drive - perhaps to a team Google Drive. And share copies of the Front-end to multiple users. Not all users would have the Desktop Access application. I presume, those users could use the Windows Access Run-time application, instead.

    What are the ramifications of doing so?

  2. #2
    Minty is offline VIP
    Windows 10 Access 2016
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    3,144
    In short it simply won't work reliably at all on a Google drive (or any other cloud based storage) because of the way Access opens the share to the database files. (SMB protocol I think, and it doesn't like being interrupted, which it would be.)

    A hardwired local network share will be absolutely fine.
    Each user should have their own local front end, Access runtime is ideal (some would say preferable) if they don't have the full Access application.
    DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
    Please use the star below the post to say thanks if we have helped !
    ↓↓ It's down here ↓↓

  3. #3
    WCStarks is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Sep 2016
    Posts
    314
    Thank you for your response. I guess I will need to see how I might implement a local network hard wired drive.

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

Similar Threads

  1. Import data to excel from an access database on the network
    By BobW2961 in forum Import/Export Data
    Replies: 1
    Last Post: 08-16-2018, 09:26 AM
  2. Replies: 3
    Last Post: 01-11-2018, 12:04 PM
  3. Replies: 4
    Last Post: 03-16-2017, 04:04 AM
  4. Can't share access over the network
    By evahaugum in forum Access
    Replies: 2
    Last Post: 07-04-2014, 08:59 AM
  5. MS-access share on network
    By miziri in forum Forms
    Replies: 1
    Last Post: 02-17-2010, 12:28 PM

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