Error - No value given for one or more required parameters

Hey everyone, I'm trying to use a recordset with an access database to pull some employee information... here is my code

Please Login or Register  to view this content.

When I run the program, the values of the variables are as follows:

myRecordSet = <Object or With block variable not set>
strConnect = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Temp\class.mdb;"
strSQL = "SELECT * FROM Employees WHERE FirstName = 'Ellen';"


Seems like there is something fishy with myRecordSet, I have loaded all the appropriate object references, but maybe there is something wrong with my declaration. Can anyone help??



Thanks,

Jimmy

ExlGuru, I greatly appreciate your assistance, but unfortunately I am required to use the recordset object in this case. That given, is there anything that seems to be visibly wrong with what I coded that would create that error? It seems to me that the myRecordSet variable shouldn't be equal to <Object or With block variable not set> but I'm not sure what is going wrong.

Do you, or anyone else, have any ideas?

Thanks again.