yoghurt_yr
November 21st, 2003, 10:47 PM
Hi,
I have two tables in one access database file.
Use ODBC to connect to the database in MFC.
Use CRecordSet to open the two tables with SnapShot modes.
In program, try to update large volume of data on these two tables alternatively. No relationship between these two tables.
Then an exception is catched,
error msg:
Could not update; currently locked by user 'admin' on machine XXX.
XXX is the name of this machine.
How to solve this problem ?
Many thanks.
I have two tables in one access database file.
Use ODBC to connect to the database in MFC.
Use CRecordSet to open the two tables with SnapShot modes.
In program, try to update large volume of data on these two tables alternatively. No relationship between these two tables.
Then an exception is catched,
error msg:
Could not update; currently locked by user 'admin' on machine XXX.
XXX is the name of this machine.
How to solve this problem ?
Many thanks.