hello,

Hi there, this is my first question in this forum!!!

i'm using VB6 with Access 2000. I change the Microsoft DAO 3.51 to Microsoft DAO 3.6 or I'll get a "unregconize data format!" error. The Access and VB is successfully link. I tried to addnew record, delete and so on, no problems found.


However, when I tried to search for a data using SQL statement, like this:

Merit.RecordSource = "select * from Rekod Merit Pelajar where Nombor Sekolah like'*" & SNoSek.Text & "*'"

Merit.Refresh



I get a "runtime error '525'----Data Access Error"!!! The error occur at the line "Merit.Refresh".

So, I download some example and tried them out. I find that the main different is that they are using VB6 with Access 97 and Microsoft DAO 3.51 but not Access 2000 with Microsoft DAO 3.6 . I found that if I change the Reference "Microsoft DAO 3.51" to "Microsoft DAO 3.6", the same error will occur in their example.

So, any idea? I really need the solution as soon as possible. Please help me if you can or show me some example on search function in db using VB6 and Access 2000. Thank you very much.