Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Intrepid
Contributor II
Contributor II

Enterprise Qlik Sense and MS Access DB data load error

Using up to date Qlik Sense Enterprise edition, I have a connection to a MS Access DB, Connection is good but if someone is logged onto the Access DB it is locked and you cannot run a data reload. If no one is logged on, the data reload runs fine, If some one is logged on you receive the error " Access DB Unavailible". Iam beginning to think that data reloads will just need to be run during off end user hours, i.e 12 midninght, 12 noon during lunch? Any help/suggestions would be appreciated.

Labels (3)
1 Solution

Accepted Solutions
Lisa_Sun
Support
Support

This is Access database locking system.  You can engage DBA to help.  The easy way is to use excel to load the data from Access while a user login Access.  Qlik Sense is like excel, a client for Access file.  So this way can help to easily troubleshoot.  

This link can be helpful.  
https://docs.microsoft.com/en-us/office/troubleshoot/access/lock-files-introduction
https://www.techwalla.com/articles/how-do-i-unlock-a-microsoft-access-database
https://www.accessrepairnrecovery.com/blog/access-ldb-or-laccdb-file-unlock
 

Help users find answers! Don't forget to mark a solution that worked for you! If already marked, give it a thumbs up!

View solution in original post

2 Replies
Lisa_Sun
Support
Support

This is Access database locking system.  You can engage DBA to help.  The easy way is to use excel to load the data from Access while a user login Access.  Qlik Sense is like excel, a client for Access file.  So this way can help to easily troubleshoot.  

This link can be helpful.  
https://docs.microsoft.com/en-us/office/troubleshoot/access/lock-files-introduction
https://www.techwalla.com/articles/how-do-i-unlock-a-microsoft-access-database
https://www.accessrepairnrecovery.com/blog/access-ldb-or-laccdb-file-unlock
 

Help users find answers! Don't forget to mark a solution that worked for you! If already marked, give it a thumbs up!
Intrepid
Contributor II
Contributor II
Author

THXS for the help Lisa...... Stan