Perfect Eric, this is agood idea, I'll start practesing it. thank u
Eric, one more thing please, How to open a database .mdb secured with a password what do i have to add to the following line :
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & myDataPath & ";Persist Security Info=False"
Best Regards
>>Well, u keep yourself far away from the Seek method !!! ???
>>Can u advice me what to use insted of the Seek method, u must be using more powerfull method.
>>
>
>Whenever possible, I don't retreive more than 250 records. I ask for criterias first than query the database with the Where clause containing the criterias specified by the user.
<><><><><><><><><><><><><><><><><><><><>
<><> REMEMBER,,,,KNOWLEDGE IS POWER <><>
<><><><><><><><><><><><><><><><><><><><>