Last Modified Date: 25 Sep 2019
Environment
- Tableau Desktop
- Microsoft Access
Resolution
Connect to an extract of the Microsoft Access database instead of using a live connection. For more information, see Extract Your Data in Tableau Help.Cause
This is a correct behavior of Microsoft Access database. When an Access database file (.mdb) is opened in shared mode, Access also creates a locking information file (.ldb) with the same file name and in the same folder as the database file. This locking information file stores the computer name and security name of each shared user of the database. Access uses this information to control concurrency. In most cases, Access automatically deletes the locking information file when the last user closes the database file.Additional Information
- Microsoft Community: Multiple Users Accessing Database
- About sharing an Access database on a network (MDB)
- Ways to share an Access database
Discuss this article... Feedback Forum
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Continue Searching
Knowledge Base
Community
Product Help
Training and Tutorials