oledb jet RecNo() equivalent RRS feed

  • Question

  • Hello,

    We're migrating a dbf based DB to Sql Server. Although the dbf tables should have unique keys, we found that this was not always the case (especially with older DB's)

    About 90% of our customers use an Advantage Database Server. Here we can use the Advantage dataprovider for .net, which has the possibility to use RowId in a query to uniquely identify a record. RowId is based on the RecNo() function.

    Unfortunately, for the other 10% we can't use the Advantage dataprovider and have to use the OleDb Jet dataprovider to read the dbf directly. I've been looking for an equivalent to RecNo() for OleDb Jet, but have been unsuccesfull so far.

    Can anybody say if OleDb Jet supports something like RecNo() or not?



    Friday, December 14, 2012 10:50 AM


  • There is no concept of record numbers in Access/Jet/ACE. The database engine operates upon primary keys or indexes.

    Access does have an autonumber or autoincrement column type for automatically generating a primary key value, but it doesn't represent a true row number in a table. That is, it's just a number that uniquely identies a row.

    Paul ~~~~ Microsoft MVP (Visual Basic)

    Friday, December 14, 2012 2:30 PM