Successful sharing of an Access database on a Windows 10 pc? RRS feed

  • Question

  • I have a situation with a customer that has an Access 2010 database frontend which is linked to another 2010 db (backend).  The backend db is normally on a server.  But this customer has it on a shared Windows 10 pc.  The backend db continues to be in a corrupted state.  

    We have many other customers that keep the backend on a server and have had no issues.

    Has anyone successfully used a backend on a Windows PC and if so, how did you accomplish it?

    We're checking with the user to see if this is a wireless connection to this shared pc.  If so, then that's probably the issue and they will no longer be able to share the backend.

    • Edited by em_rdh Wednesday, May 27, 2020 3:28 PM
    Wednesday, May 27, 2020 3:21 PM

All replies

  • We're still waiting on the user to get back to us about the wireless connection.  In the meantime, a coworker and I set up a shared folder that contains the backend.  We've tested adding,editing, and deleting data from our pc's and have had no issues.
    Wednesday, May 27, 2020 5:34 PM
  • You might also want to be sure that your back end machine does not go to sleep or hibernate.  Also I'm sure someone else will chime in with this but you could migrate that back end to a cloud based SQL server (e.g. Azure).


    Wednesday, May 27, 2020 6:10 PM
  • Since you are working with Windows 10, then there is a VERY HIGH probability you are dealing with https://www.devhut.net/2018/06/13/access-bug-database-is-in-an-unrecognized-format/

    Daniel Pineault, 2010-2019 Microsoft MVP
    Professional Support: http://www.cardaconsultants.com
    MS Access Tips and Code Samples: http://www.devhut.net

    Wednesday, May 27, 2020 7:01 PM
  • Thank you both so much.  We will check these out on the customers' pc.
    Wednesday, May 27, 2020 8:10 PM
  • Probably you need to implement some kind of logging...provided that you are not having the "server" computer falling to sleep/hibernate..make sure to check the network latency
    Monday, June 1, 2020 11:17 AM