BUG: "??? ?? ???? ???? ?? INSERT INTO..." ??? Recordset.Update ADO

?????? ????????? ?????? ?????????
???? ???????: 189220 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

???????

??? ??????? ??????? AddNew ?? ??????? ??????? ????? ?????? ????? "? ??? ????? ????? ??????:
???? Microsoft OLE DB ?? ??? ????? ????? ODBC '80040e21'
[Microsoft][?????? ????? Microsoft Access 97 ODBC] ??? ?? ???? ?????? ?? ????? INSERT INTO ???????.
???????? version4.00.4202.00 ?????? ????? ODBC ?????? Microsoft ?? ??????? ????? ?????:
??? ??? ??????? '-2147467259(80004005) ':
[Microsoft][?????? ????? Microsoft Access ODBC]??? ?? ???? ?????? ?? ????? INSERT INTO.

?????

???? ??? ????? ??? ???? ??????? ?????:
  • ??? CursorType adOpenForwardOnly (0).
  • ??? CursorLocation adUseServer.
  • ????? ????? ??? ????? ?? ??? ?????.
  • ??????? ?????? ????? ODBC Access Microsoft.
??????? ?????? AddNew ?????? ??? ???? ???? ?????? ? ?????? ??? ????? ??? ?????. ???? ?????? ?????? ActiveX (ADO) ??????? ?? ??? ??? ????? ????????? ???????? ?????? ????? ????? INSERT ?????? ???????. ????? ???? ADO ????? INSERT, ?? ?????? ????? ??????. ????? ????? ????? ?????? ???? ????? ??? ????? ??? ?? ???? ????.

??? ???? ??????? ???? ????? INSERT ???? ??? ???:
   INSERT INTO Table ([field with space]) Values(value)
				
ADO ?????? ????????? ???????? ???????:
   INSERT INTO Table (field with space) Values(value)
				

????

???? ??? ??? ???? ??????:
  • ?? ?????? ???????? ?? ????? ?????? ?? ????? ????????.
  • ?????? CursorLocation adUseClient (3).
  • ?? ?????? CursorType adOpenForwardOnly (0) ? ??? adOpenKeyset (1) ?? adOpenDynamic (2) ?? adOpenStatic (3).
  • ????? ??????? ?????? ????? ?????? ?? ????? INSERT ?? ???????? ??? ????? ?????? ????? ?? ??????? ?????? AddNew ????????.
  • ?????? ???? Microsoft OLE DB ????? Jet 3.51 ?? 4.0 ????? ?? ???? Microsoft OLE DB ?? ODBC ?????? ????? ODBC Microsoft Access.

?????

???? Microsoft ?? ???? ??? ?? ?????? Microsoft ??????? ?? ????? ??? ??????? ???.

???????

???? ???????: 189220 - ????? ??? ??????: 21/????/1426 - ??????: 2.2
????? ???
  • Microsoft Data Access Components 1.5
  • Microsoft Data Access Components 2.0
  • Microsoft Data Access Components 2.1 Service Pack 2
  • Microsoft Data Access Components 2.5
  • Microsoft Data Access Components 2.6
  • Microsoft Data Access Components 2.7
  • Microsoft Open Database Connectivity Driver for Access 3.5
  • Microsoft Open Database Connectivity Driver for Access 4.0
????? ??????: 
kbmt kbbug kbdatabase kbdriver kbjet KB189220 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????189220

????? ???????

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com