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 !