Problem with Locate Function using Access 97

Steve Hunt

Delphi Developer

Mon, 15 Jan 2001 03:00:00 GMT

Problem with Locate Function using Access 97

I am having a problem using the "Locate" function in Delphi 3 using an
Access 97 table.

The system returns a EDBEngineError with message "No current record" when
attempting to look up data in the table. The table has the data which can
be read in a DBGrid control and the code works fine against Interbase and
Paradox tables.

Can anyone help?

Pramod Nadi

Delphi Developer

Tue, 16 Jan 2001 03:00:00 GMT

Re:Problem with Locate Function using Access 97

Quote

Steve Hunt wrote in message <01bdbc04$70342ac0$0a01a8c0@shunt>...
>I am having a problem using the "Locate" function in Delphi 3 using
an
>Access 97 table.

>The system returns a EDBEngineError with message "No current record"
when
>attempting to look up data in the table. The table has the data which
can
>be read in a DBGrid control and the code works fine against Interbase
and
>Paradox tables.

>Can anyone help?

Try putting LoCaseInsensitive or LoPartialKey in the Options. I
presume you are running BDE5.0

Pramod

Other Threads

1. access violation when using aggregate functions in ADO/Access 97

2. Problems with the locate command and Access 97

3. Problems using ACCESS 97 driver

4. Accessing Delphi (Paradox?) data using Microsoft Access 97

5. D5-ADO-MS ACCESS 97 database-MS Office 97 Access ODBC driver-Autoincrement probs

6. Function to determine if Access 97 or 2000 mdb file Format

7. Problem with MS Access 97 database, accessed by group of users

8. problem with locate using access db

9. QReport doesn't work when native connection to MS Access 97 is used

10. locking records in Access 97 using Delphi 3.0