how to make faster execution time for vb

[NJman]

Hi everyone,

I have an interface (a form using visual basic code) to execute sql statement to update the database access 2007 on sql server. The interface takes a long time to execute the sql statement. Does anyone has any idea how to speed up the run time execution for vb? Thanks in advance

[Phil Weber]

Difficult to say without seeing your code. Please post your SQL query and the code you're using to execute it.

[NJman]

Here is my code:

Private Sub cmdResetNotSelectedCustomer_Click()

If dropdown.ItemData(dropdown.ListIndex) <> vbNullString Then
Dim selectCustomer As String
selectCustomer = CStr(dropdown.ItemData(dropdown.ListIndex))
If msgbox("Do you want to RESET all Customers except " & selectCustomer & "?", vbYesNo + vbQuestion, "Reset Customer") = vbYes Then
Dim strSQL As String
strSQL = "UPDATE Main SET Downloaded = 0, Errors_Fail = 0, Error_Code = '', Time_Updated = '' WHERE Enabled = Yes And Customer <> '" & selectCustomer & "'"
CurrentDb.Execute (strSQL)
End If
Else
msgbox "Please select a Customer", vbInformation, "Select Customer"
End If

End Sub

[Phil Weber]

Do you have indexes on your Enabled and Customer columns? If not, try adding them; that should speed up your query execution.

[NJman]

Phil, How can I add index in Enabled and Customer? Can you show me a sample of code? Thanks

[Phil Weber]

If it's a SQL Server database, see http://www.google.com/search?q=sql+server+create+index . If it's an Access database, see http://www.google.com/search?q=access+create+index .