Be careful with this one.

we have tables with 6 million rows and doing

WHERE (CustomerName = @CustomerName OR @CustomerName IS NULL)

killed perfomance. The query took more than 2 minutes.

User dynamic SQL...

dim qdf as querydef

dim sqlconnectstring as string

sqlconnectstring = codedb.tabledefs("MySQLServerAttachedTable").connect

set qdf = new codedb.createquerydef("")

qdf.connect = sqlconnectstring

qdf.sql = "spMyStoredProc " & myvariable1 & "," & myvariable2

qdf.execute

OR

set rs = qdf.openrecordset()

qdf.close

set qdf = nothing

Try each of the following. Let me know if either one has a significant speed improvement

UPDATE ACL

SET ACL.SendNews = Cust.SendNews

FROM [EmailDB].dbo.Customer as Cust INNER JOIN [WebDB].dbo.ACL as ACL

ON Cust.CustID =...

'in Access, in one of the events for the txtEmpID text box control

dim MyEmployeeID as long

MyEmployeeID = frmEmployee!txtEmpID

dim sql as string

sql = "UpdateInfo " & CStr(MyEmployeeID) 'no quotes because @empid...

The article on Triggers did not mention that the Trigger is fired only one timer per DML statement - Insert, Update, or Delete. The SQL Data Manipulation Statement may affect...