🚀 go-pugleaf

Hello

I'm using BCB enterpise with ADO Update 1. I have an app with a simple 
query that returns 1 record against an Access 97 table under ADO 2.5 
(ie, a Win 2K machine with Access97 installed), but returns no record 
under ADO 2.6 (a Win 2K machine with Access 2000 installed) when run 
against the same mdb file (either shared from the first machine or 
copied to a local drive). The query returns 1 record when pasted into 
the SQL window of either Database Desktop or SQL Explorer and run 
against the mdb file via ODBC.

Here's the query:

   Select RawDataID, DataParent from header
   where JobKey = 1443

I've tried parameterizing the value of JobKey, typing it in as a literal 
part of the SQL string, and passing it in as a String that is appended 
to the SQL statement. In all cases, once I call Open() on the TADOQuery, 
calling First(), RecordCount(), or just attempting to read the returned 
values throws an Exception.

If I remove the where clause, the query still returns no record even 
though I know the table exists and contains data. Other tables in the 
same Access mdb file are returning data. Since the call to Open() 
succeeds, I presume the table name of 'header' is allowed.

I'm stumped. Can anyone suggest what's wrong?

Thanks
David