SQL & FindFirst & Bookmark

[rberkers]

Hello,

We are doing some tests for moving the data from our MS Access 2007-applications to an MS SQL 2005-server. And so far all is going very well. I have one small issue though.

In a form we have for each letter in the alphabet a button to move to the first occurrence begin with that letter. Like this:

Under each button in the click-event the next source is placed (which of course the letter changing per button):

    Call Clear_Comboboxes
    Dim rs As Object
    Set rs = Me.Recordset.Clone
    rs.FindFirst "Left([Last_Name], 1) = 'G'"
    Me.Bookmark = rs.Bookmark

Private Sub Clear_Comboboxes()
   Me.Find_Name = Null
   Me.Select_Function = Null
   Me.Select_Department = Null
End Sub

With the Jet-engine this worked perfect. Under MS SQL is it very slow.

Could someone give me some advices how to change this (and why it is so slow now).

Thanks.

Regards,
Rob.