AutoNumber

[alex1973]

I have an Access 2000 database with a AutoNumber field (also PrimaryKey). The problem I have is that when I try to get a record I receive 0 from the AutoNumber field. Also, when I use the DataGrid control the coresponding column has only zeros.
I use ADO.
What could be the problem?
Thanx.

[Chris Eastwood]

I remember reading an old copy of VBPJ (from early last year, I think), that mentioned this 'bug'. If I remember correctly, then it's a bug with the version of ADO that you use (of course, I could be wrong) - I think they mentioned that it was fixed in ADO2.1/2.5


Chris Eastwood

CodeGuru - the website for developers
http://codeguru.developer.com/vb

[alex1973]

I don't know about the bug, but I'm using ADO 2.1 and I've also found the problem. I had to set the Format property of the field to General Number in Access.
Thanx anyway.