Hello again!
I have a slight problem, I have a SQL statement that works fine in Access, but on inserting it into ASP.DB I get the following error,

Error # (Get_RS_GetCount - 1 -SELECT COUNT(*) as c FROM Diary WHERE Salesperson IN (Mike,Sallyanne,Rita) AND MeetingDate >=Now()-1) = 80040E10(-2147217904)
Description = [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 3.
Source = Microsoft OLE DB Provider for ODBC Drivers
SQL State = 07001
Native Error = -3010

Does this error have anything to do with the dbNameMap??

Any help would be appreciated, even 'I think it's about time you gave up!!'
Regards
Melanie