1

We have an Access database with a split front/back end. The back end resides on a Samba 4.1.6 share with around 15-20 users. Frequently the database will popup with the error "Network access has been interrupted". Obviously this is not ideal.

When we move the back-end to a Windows home server share the issues do not persist, so as far as I'm aware this rules out any hardware issues within the network itself.

Has anyone else encountered the same issue? Or anybody have any ideas?

0

Has anyone else encountered the same issue?

Yes. The Access Database Engine is designed to work with "real" Windows file sharing and Samba – or at least some versions of Samba – apparently do not implement all of the low-level features of the SMB protocol that are needed for the Access Database Engine to work reliably.

(ref: Corrupt Microsoft Access MDB Causes - Samba)

| improve this answer | |
  • A MySQL back-end on a non-Windows server will not have the same issue because Samba will not be involved (assuming that each user has their own local copy of the Access front-end, which is absolutely required for reliable multi-user operation). – Gord Thompson Dec 4 '15 at 11:45

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.