search cancel

Microsoft Access version 16 database in File Share protected folder is corrupted when shared

book

Article ID: 188501

calendar_today

Updated On:

Products

File Share Encryption

Issue/Introduction

If a Microsoft Access database is stored in a File Share protected network share, a single user can successfully make changes to the data in the database.

However, if two or more users access the database concurrently, even if they do not open any database tables, once both users have closed the database, the database file cannot be opened again. Note that the *.laccdb Record-Locking Information file is created and deleted as expected.

When a user tries to open the database file they see an error message like this where \\computer\share\fileshare\protected\mydb.accdb is the full path to the database file:

Unrecognized database format '\\computer\share\fileshare\protected\mydb.accdb'.

Environment

  • Symantec File Share Encryption 10.5 and above.
  • Microsoft Access version 16.

Resolution

To workaround this issue, make the database available only to one user at a time. To do this, from the File menu, click on Options and then on Client Settings. Under Default open mode, enable Exclusive. This will mean that one user can open the database but when another user tries to do so they receive an error message like this where \\computer\share\fileshare\protected\mydb.accdb is the full path to the database file:

Could not use '\\computer\share\fileshare\protected\mydb.accdb'; file already in use.

Broadcom is committed to product quality and satisfied customers. This issue is listed as a Known Issue in the Release Notes for release 10.5 MP3. It is currently being considered by Broadcom to be addressed in a forthcoming version or Maintenance Pack of the product.

Please be sure to refer back to this article periodically as any changes to the status of the issue will be reflected here.

Additional Information

EPG-23599