If you are writing a query against an Access database backend, you need to use the following join syntax: select t1.c1 , t2.c2 , t3.c3 , t4.c4 from ((t1 inner join t2 on t1.something = t2.something) inner join t3 on t2.something = t3.something) inner join t4 on t3.something = t4.something The table and column names … Read more
Couple of tips after working with asp-classic for years There is no need to create a ADODB.Connection you can pass a connection string direct to .ActiveConnection property of the ADODB.Command object. This has two benefits, you don’t have instantiate and open another object and because the context is tied to the ADODB.Command it will be … Read more
You need to use an ADODB.Command object that you can add parameters to. Here’s basically what that looks like Sub adotest() Dim Cn As ADODB.Connection Dim Cm As ADODB.Command Dim Pm As ADODB.Parameter Dim Rs as ADODB.Recordset Set Cn = New ADODB.Connection Cn.Open “mystring” Set Cm = New ADODB.Command With Cm .ActiveConnection = Cn .CommandText … Read more