Hi,

Why Table1.RecNo doesn't work with Access97 tables?
It always returns -1? instead of the record number of the current record

in the dataset.
In Paradox tables there is no such problem.
I'm using Delphi 5.

Thanks,
Roumen
?
?

For SQL backends RecNo does not have real symantic sense.  Access is treated as
a SQL backend by the BDE.  One thing you can try is doing a Last or Fetchall to
get alll the records over to the client side and then the BDE will usually have
a good RecNo and RecordCount values.

--
Jeff Overcash (TeamB)
      (Please do not email me directly unless  asked. Thank You)
The bond that links your true family is not one of {*word*76}, but of respect and joy
in each others life.  Rarely do members of one family grow up under the same
roof.   (R Bach)

The BDE does not use record numbers properly for SQL databases. You must
somehow implement your own record numbering scheme in memory if you want to
actually keep track of them. This is a flaw in my opinion, at least for
Access, because Access does have an absolute position method which provides
record numbering.

--

Woody

news:388AE6E8.1F28C55C@dunav.net...