Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to get all records in straight table without missing?


Hi,

I have a straight table with data. The columns are

Name, DateEntered, DaysinQueue.

All the records are updating from access database. But there ate two records in access database with DateEntered as 28/04/2014 12:16:36 and another record with DateEntered as 28/04/2014 13:43:18. Only these two records are not updating in the file.

Could anyone suggest me how to get this records?

Thanks.

33 Replies
Not applicable
Author

Thanks. I an able to see the below error. could you suggest me what it means?

Error: QVX_UNEXPECTED_END_OF_DATA: SQL##f - SqlState: S1000, ErrorCode: 4294965685, ErrorMsg: [Microsoft][ODBC Microsoft Access Driver] The Microsoft Access database engine stopped the process because you and another user are attempting to change the same data at the same time.

EDIT: I am getting the same error message as

The Microsoft Access database engine stopped the process because you and another user are attempting to change the same data at the same time.

when I am copying entire table data from access.

Greg_Hood
Employee
Employee

The error message is quite explicit, are you sure it doesn't apply?   The only other bug record I can find with Unexpected_End_of_data related to some records with character types which were causing a problem, but the error description returned was not the same.

Not applicable
Author

Thanks. Yes you are right. Finally I found the solution as compact and repair the database. That's now solve the problem for time being.

Greg_Hood
Employee
Employee

Good to hear!