Hi,

I have a problem when i use seek command with multiple keys on Windows 98.

I test command on Windows XP and don't have problem. When i run my command on Windows 98, the result is different.

I use DAO 3.6 reference, with database Access 97.

I have table with index on 2 fields. (Index name= "Ean;SeqId")


Sample:

dim rs as recordset
Set rs= opendatabase("c:\test.mdb").openrecordset("Transactions")

rs.index= "Ean;SeqID"

rs.seek "=", "9781234567890" 'I use 1 keys for match to the first items
if rs.nomatch then '
...
else
...
endif


Thanks in advance,
Roger