Using SQL instead of DAO 2

[Jackvmae]

I recently read that it is faster to add a record to a table using SQL instead of DAO. So I would like to change my DAO code to SQL, but all the SQL syntax I've tried results in errors. Can someone provide me with SQL syntax to accomplish the same as this DAO procedure:

Dim db As DAO.Database
Dim rst As DAO.Recordset

Set db = CurrentDb()
Set rst = db.OpenRecordset("tblCustomers&quot

With rst
.AddNew
!CustomerName = Me.CusName
!CustomerTitle = Me.CusTitle
.Update
End With

 

[TonyJollans]

Hi Jackvmae,

I'm not sure what your performance gain will be on a single record insert but here it is:

[blue]

DoCmd.RunSQL "INSERT INTO tblCustomers ( CustomerName, CustomerTitle) VALUES ('" & Me.CusName & "', '" & Me.CusTitle & "');"

[/blue]


Enjoy,
Tony

------------------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading FAQ222-2244 before you ask a question.

 

[cheerio]

Before you rush to change, think about error handling and think about interaction with the user.

What happens if the customer already exists
(a) in your DAO code
(b) in Tony's code
?