Results 1 to 7 of 7
  1. #1
    raychow22 is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    May 2017
    Posts
    145

    Frontend to Backend Databases

    Hi Forum,



    I split my database into two databases "Frontend" and "Backend". THey are located in my OneDrive. OneDrive duplicates the Backend file in the case of two users trying to save data and/or make changes to the Frontend database at the same. Now I have two Backend files which I need to reconcile the data into one. Are there any preventative measures to ensure duplication doesn't happen.

    Thanks!

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    Not familiar with OneDrive so don't know if this will fix, but each user should run their own copy of the frontend and only one person (the developer) should make design changes to either file. Distribute new versions of the frontend to users.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    raychow22 is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    May 2017
    Posts
    145
    Quote Originally Posted by June7 View Post
    Not familiar with OneDrive so don't know if this will fix, but each user should run their own copy of the frontend and only one person (the developer) should make design changes to either file. Distribute new versions of the frontend to users.
    Users do have their own copy of the Frontend. How do we make sure that all users data are saved into the backend? I'm thinking about 8 people will have their own frontend database and the chances of them entering the database at the same time is very likely. I want to be able to fullproof this. Any suggestions help!

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    I have multi-user split database with backend on a normal file server and never had issue of the backend duplicating.

    For possible clue as to what is happening, review:

    https://answers.microsoft.com/en-us/...1-78095629109f

    https://social.technet.microsoft.com...icesetupdeploy

    https://answers.microsoft.com/en-us/...7-c10853fa81a1
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    raychow22 is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    May 2017
    Posts
    145
    What is the file server you use? I may have to use alternatives if OneDrive does not perform like I want it to.

  6. #6
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    The server is some dedicated computer managed by IT.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  7. #7
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    OneDrive and similar facilities such as DropBox only provide exclusive access to one user at a time - in the same way as Excel works - first user to open can do what they like, subsequent users have to save changes they make to a new file.

    Simply, it is not a suitable host for a back end.

    If your situation is multiple users at multiple locations and they do not all share a common network you will need to look at a different solution for the backend such as SQL Azure (which is sql server). It isn't free, but does not cost a lot - depending on usage perhaps $10-$20/month. Drawback is every user will need a fixed IP (ISP's usually make a small one off charge, perhaps $5-$10) since this is the main firewall against attacks. Providing you are not using lookups, multivalue or calculated fields it is relative easy to upsize. But again not suitable if users are working out of wifi hot spots.

    There is also SharePoint. I don't use it (bad experience when it was first launched) and I don't know whether putting the backend on sharepoint will even work for one user, let alone multiple users. But there are sharepoint lists - basically you convert your tables to lists.

    Other alternatives include using terminal server or citrix - benefit is you can still use your access backend but again, at a cost, possibly a lot more than SQL Azure.

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

Similar Threads

  1. Frontend Backend Databases Forms to Tables
    By raychow22 in forum Access
    Replies: 2
    Last Post: 07-08-2017, 03:49 AM
  2. Linked tables from frontend keep disconnecting from backend db
    By Villa123 in forum Import/Export Data
    Replies: 2
    Last Post: 06-02-2016, 07:53 AM
  3. Frontend Backend Database Questions
    By data808 in forum Access
    Replies: 29
    Last Post: 03-26-2014, 11:58 PM
  4. Access Switching to frontend and backend
    By caliskier in forum Access
    Replies: 4
    Last Post: 11-19-2012, 11:58 AM
  5. Replies: 1
    Last Post: 01-12-2012, 09:43 AM

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