Table returing same values for all the records:bug in DAO 3.51 libraries

[Manish Singh]

Hello,

I have a table which I read and it is returning me the same value for all
the records present. This problem is only happening on a Windows 2000 SP4
machine with Access 97 SR2 installed.

Any clues why this is happening. I suspect a bug in DAO 3.51 libraries. Any
pointers, help would be greatly appreciated.

TIA,
Manish

 

[gandalf]

What is your query and what do you which it to read?

 

[Manish Singh]

Actually,

The table is in a database and the code is in an ActiveX server. The code
simply opens up the Table using dbOpenSnapshot and used the FindFirst to
read the data pairs.

The table contains data in pairs e.x.

NameOfProperty Value

In FindFirst, the name of Property is passed and then the corresponding
value is read. This is happening randomly only with Access 97. Sometimes it
reads the values properly and other times, it simply behaves as if there was
only one record in the table and returns values only for that record. It is
unable to find the passed 'NameOfProperty'

Any clues??

Thanks & Regards,
Manish