RE: Autonumber field alway set to 0 using OLEDB? Using ODBC works fi

Hi Morris,

First of all, I would like to confirm my understanding of your issue. From
your description, I understand that when you're using Jet 4.0 for oledb
provider to insert records to an Access 2000 database, the auto number
field value is always 0. If there is any misunderstanding, please feel free
to let me know.

Based on my research, this is a known issue. I assume that you're using a
client side cursor. You can try to check the following KB articles for more
information and resolutions on this issue.

http://support.microsoft.com/?id=190370
http://support.microsoft.com/?id=195910
http://support.microsoft.com/?id=221931

HTH.

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."

.

Relevant Pages

  • Re: SQL slammer, i have it, awww geez now what?
    ... >have fix) and mine says MSDA and JET 4.0 and is OLEDB ... >Provider for ODBC drivers I shut down ports ...
    (microsoft.public.sqlserver.security)
  • Re: Verbindungsserver Microsoft.ISAM.OLEDB.1.1
    ... Provider verwenden, den Jet 4.0 Treiber mit seiner ISAM ... Funktionalitäten oder den VFP OleDB Provider. ...
    (microsoft.public.de.sqlserver)
  • =?Windows-1252?Q?Re:_Abfrage_=FCber_mehere_DBs_=28Access=29?=
    ... Statement und den verwendeten Provider (hier Jet, bzw. OleDb) ... http://www.asp-solutions.de/ - Consulting, Development ...
    (microsoft.public.de.german.entwickler.dotnet.datenbank)
  • Re: Update funktioniert nicht
    ... OleDb - Provider gültig sein? ... Auszeichnung von Parametern in OleDb spezifiziert? ... Jet erwartet einen anderen SQL-Dialekt als z.B. der OleDb-Provider für den ...
    (microsoft.public.de.german.entwickler.dotnet.datenbank)
  • Re: nVarchar limitations using OLEDB provider
    ... but not nvarcharor greater using a clientside cursor. ... is IMHO what OLEDB is designed for: ... Unless of course this OLEDB provider is not supported at all..... ... The issue may actually lie on the client code and not on the ...
    (microsoft.public.sqlserver.ce)