Helo ,
I'm working on a program - open a database (mdb file) which has 40,000 records . I need to search one of the records - depand of what the user want.
My problem :
I use the form_load event to open the database (ado code)
the code is :
Private Sub Form_Load()
' opens the database :
Set sb = New Connection
sb.Open "PROVIDER=Microsoft.Jet.OLEDB.3.51;Data source=C:\drawings\db2.mdb"
Set adoPrimaryS = New Recordset
adoPrimaryS.Open "select * from SIGNALS", sb, adOpenForwardOnly, adLockReadOnly
End Sub
the problem is that it takes too long to search for the record.
when I add the command cursorlocation = useclient , it's even worse - the form load realy slow - why ??
What can I do to solve it?
Thanks in advance , Moyalt.
p.s - I use sql "where" statment for searching the record !
