OleDB Concurrency Error

Jun 5 2006 6:33 PM
Hi, I'm coding a WFA for some cheap people who want to use Access 2002 as a DB as they already have a licenced Office 2002. Everything is set in the application except updating records. I let them update from a DataGrid, but it throws a Concurrency Exception, which I am guessing is due to a type-mismatch. In VS 2005, the DBType of the primary key field shows as Object when I debug, and I can not find a matching OleDBType to add to the parameter. Here's the part of the code: string updateQuery = "UPDATE product SET [no] = @no, maincat = @maincat, name = @name, artist = @artist, cover = @cover," + " genre = @genre, sub = @sub, dub = @dub, disc = @disc, extra = @extra, amount= @amount WHERE id = @id"; tb_Adapter.UpdateCommand = new OleDbCommand(updateQuery, tb_Connection); gridParam = tb_Adapter.UpdateCommand.Parameters.Add("@id", OleDbType.Numeric); gridParam.SourceColumn = "id"; gridParam.SourceVersion = DataRowVersion.Current; id is the primary key. So far I have tried Integer, Numeric, ShortInt, Unsigned Int. None of them work. If anyone can tell me the type of AutoNumber in terms of OleDBTypes in 2005, it'd be greatly appreciated.