Kbase 20761: Microsoft Access 2000
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Unverified
FACT(s) (Environment):
ODBC DataServer
SYMPTOM(s):
Microsoft Access 2000
MS Access 2000 Write Conflict Error when Updating Records
You might encounter the following error: ACCESS Write Conflict.
The error can occur even when there is only one user connected to the database.
FIX:
In a recent example, a Progress customer was running a simple update that failed in MS Access 2000. The same update command worked in winSQL, ODBCTEST, and MS Excel 2000.
A look at the SQL.log revealed the reason for the error. The ODBC
driver (SQL-92) received the following from MS Access when the update ran:
MSACCESS fffc82ef:fff9f7e3 ENTER SQLExecDirectW
HSTMT 0x07fb1ac0
WCHAR * 0x09c962e8 [ -3] "UPDATE "PUB"."ap_bank" SET "abm_name"=? WHERE "abm_num" = ? AND "abm_name" = ? AND "abm_cashacct" = ? AND "abm_lstchk" = ? AND "abm_account" = ? AND "abm_checks" = ? AND "abm_chkaln" = ? AND "abm_chkst" = ? AND "abm_extrada2" IS NULL AND "abm_extrach1" IS NULL AND "abm_extrada1" IS NULL AND "abm_voidcks" = ? AND "abm_extralo1" = ? AND "abm_oexport" IS NULL AND "abm_extralo2" = ? AND "abm_extralo3" = ? AND "abm_extrade1" = ? AND "adm_extrain1" = ? AND "abm_recon" IS NULL AND "abm_extrachc3" IS NULL AND "abm_extrachc2" IS NULL AND "abm_extrachc1" IS NULL AND "abm_extraloc1" = ? AND "abm_userch1" IS NULL AND "abm_userin1" = ? AND "abm_userde1" = ? AND "abm_userlo1" = ? AND "abm_userda1" IS NULL AND "co" = ? AND "div" = ? AND "abm_extrainc1" = ? AND "abm_extradec1" = ?\ 0"
SDWORD -3
WinSQL passed the following for the same command:
Winsql fff71d79:fff5064d ENTER SQLExecDirect
HSTMT 0x00d6091c
UCHAR * 0x016cd394 [ -3] "UPDATE pub.ap_bank\ 9SET abm_name = 'M&T - PSSI' WHERE abm_num = '50'\ 0"
SDWORD -3
SQL.LOG entries for ODBCTEST and MS Excel 2000 were identical to WinSQL. This is not a progress issue. If you experience the problem, please contact Microsoft.