I m using vb6 and access 2000 for my app.
my database table has around 90,000 reocords with size of 114MB FILE size.
Which database connection should i used for getting result using like operator. Should i used ado , rdo or dao ?
I also want to enforce database security for my file.
Download for FREE the ADO/DAO Data Controls that makes life EASIER developing database applications in: VB, FoxPro, Access, VC++, .NET etc... Navigate, Add New, Delete, Update, Search, Undo and Save your changes. Supports Disconnected Recordsets and Transactions!
Or try our Ask An Expert service to answer any of your questions!
Are you preparing your tables before openning them? You may want to try to set the prepare to true before openning. Remember you will need to update your statistics unless your database system does it automatically. The other things you can do is avoid using * in your select. Specifiy the fields you want to use. One last thing is how is your Connection doing its reads. You may want to set it to Dirty Read. I hope this helps.