access query not returning all records

[Sinead ORiordan]

I am running a vb6 application which accesses an SQL server database and
an Access database. I have a table in the access db which is populated
every time i run the vb app. However, when i run the application and
run an access query which just changes the order of the above table to
get the recordset, there is one record missing, always the same record.
Can anyone please help me as i can't solve this as the record is not
missing from the access table or query????
It is always the same record missing from the recordset.

Any ideas??
Many thanks

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!