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


'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.