Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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.
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.
Good to hear!