Hello Every Body,

Environment :- VB5 Pro. with WIN98 Database:- MSACCESS 8.0


I am Facing a peculier problem.Im am Using DAO objects for dealing with

the database part.When I opened the visdata for the first time it asked

for the system datebase and i supplied the rigth path for it .i.e

c:\windows\system\ and satrted working with it.But I noticed a very odd

problem i.e When I created a table and it has 3 fields.

And all three of them text varibles with 255 size .

The Problem When I am giving a plain select in visdata like

select * from tablename;

It is Showing correctly all the results.

But when I am giving a where clause a maxmium it is showing only 2

records.And This problem is not only with this table with all the tables it is happening . i.e only 2 records are fetched at max. when a "WHERE "Clause is given.

Is there any setting involved.

Please help

With Regards

Venkat