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

    Frontend Backend Databases Forms to Tables

    Hi Forum,

    Is there a way to full proof the frontend user database so that all the data makes its way to the backend? Sometimes users in the front end use its Forms simultaneously and not all the data will transfer to the backend. However, Access does make a duplicate of the database to ensure that the data is still saved. What are some things I can do to keep all the data together and avoid having created multiple backend databases?

    Thanks!

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Each user should run their own copy of the frontend.

    I have never had the issue you describe. I have never had Access create a copy of the backend, the frontend yes.
    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
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    sounds like you have the backend on something like dropbox?

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

Similar Threads

  1. Replies: 11
    Last Post: 02-24-2017, 06:25 PM
  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. backend-tables in cloud, frontend on desktop
    By raffi in forum Import/Export Data
    Replies: 4
    Last Post: 12-15-2014, 11:57 AM
  4. Frontend Backend Database Questions
    By data808 in forum Access
    Replies: 29
    Last Post: 03-26-2014, 11:58 PM
  5. Access Switching to frontend and backend
    By caliskier in forum Access
    Replies: 4
    Last Post: 11-19-2012, 11:58 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