Hi, I am getting this error when running the following code:

Microsoft JET Database Engine error '80040e10'

No value given for one or more required parameters.

/newsletter_generator/view_past_newsletters.asp, line 21

Code:

<%
'Dimension variables
Dim adoCon 'Holds the Database Connection Object
Dim strSQL 'Holds the SQL query to query the database

'Create an ADO connection object
Set adoCon = Server.CreateObject("ADODB.Connection")

'Set an active connection to the Connection object using a DSN-less connection
adoCon.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & "d:\inetpub\sussexenterprise.org.uk\web\db\newsletter_content.mdb"


'Create an ADO recordset object which will hold the records from the database.
Set rsExhibitors = Server.CreateObject("ADODB.Recordset")

'Initialise the strSQL variable with an SQL statement to query the database
strSQL = "SELECT tblContent_members.Comment, tblContent_members.DateSent FROM tblContent_members"

'Open the recordset with the SQL query
rsExhibitors.Open strSQL, adoCon

%>


I'm using almost the same code for accessing another DB in the same directory, which runs fine. Please help me find what is going wrong.

Thanks