OLEDB, IsAutoIncrement, Access Autonumber field, not working...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Dim oComm As New OleDb.OleDbCommand("SELECT * FROM " & _formattedtablename & " WHERE 1=-1", _Connection)
Dim oReader As OleDb.OleDbDataReader = oComm.ExecuteReader(CommandBehavior.SchemaOnly)
Dim oTable As Data.DataTable = oReader.GetSchemaTable

This:
oRow.Item("IsAutoIncrement")
Returns false even if the column is an Access autonumber field.

Any ideas?
 
It has been more than 3 days. Isn't someone at MS going to answer this? Is that no longer part of the MSDN subscription? Was my original message not connected to my subscription?
 
Let's try again. My question is: Does this happen to everyone? If so, is this a bug in the OLEDB driver for Access (I tested on 2000) or some kind of problem with the OLEDB namespace classes in ADO.NET? If it is a problem, will it be tagged as a bug and fixed?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Migrating from MS ACCESS 97 to SSEv 1
Data is different than in database 3
Writing a Memo field to an Access DB with OleDB 5
SQL to ACCESS via VB.NET/ADO.NET 4
Problem with insert statement... 5
CommandBehavior.KeyInfo - iskey info is always false with provider my MySqlProv.3.0) 0
How can I Return a selected row without the Frist column (ID autonumber column) ?? 2
0x80020003 DISP_E_MEMBERNOTFOUND When working with Excel Spreadsheet 0

Back
Top