I am using ADO 2.6 connection and recordset objects to access VFP tables.

My project forms are using the standard VCR-type record navigation buttons (First, Previous, Next, Last) but because the ADO recordset BOF and EOF properties don't return true until I try to position before the first record or after the last record (due to the way .DBF tables are structured), I'm getting that annoying repeating first and last record.

Does anyone know an efficient way to handle the phantom record when BOF and EOF is encountered?

Thanks.