DB access problem

[johnnyv]

I have created an app that uses an Access DB within the app I write records to a table then qeury the table based on criteria. It will pull back records as needed until it hits the last query. The last query is simple enough
SELECT * FROM INF_Prof where name = 'joe'

The table does have a record taht contains a field with teh value of joe

when I run this on an w2000 box it execute correctly
when I run it on an XP, win98 boxes it tells me that either bof or eof is true or record does not exsist. yet the record is there and the can read or write to this table?

if I open access directly and run this sql statement it returns a record on a win98 box but not if I run the sql statement from within the app.

Kind of a vague discription I know but can anyone tell me how to go about debugging the problem?

 

[zemp]

Are you using ADO or DAO? If ADO, are the versions the same on each machine? Am I correct to assume that the Access version is the same on all machines?

Might the field 'name' be interpreted as a keyword? I like to surround all table and filed names with square brackets just to make sure. Try,

SELECT * FROM [INF_Prof] where [name] = 'joe'

zemp

 

[bjd4jc]

I am not sure when case matters in these queries but you may also want to consider using the LCase function in your query:

SELECT * FROM [INF_Prof] where LCase([name]) = 'joe'