Invalid Argument

[azrina]

Hi all.

My web based system is using ASP and Ms Access database.
I got an error at some page which the error is:

Microsoft JET Database Engine (0x80004005)
Invalid argument.
/jabatanlaut/LogGagal.asp, line 54

I dont have any idea how to solve this "Invalid Argument" problem.
Below is the code which this error pointed to (line 54).

rs22.open"SELECT CHECKINOUT.USERID, CHECKINOUT.CHECKTIME, CHECKINOUT.CHECKTYPE, CHECKINOUT.VERIFYCODE, CHECKINOUT.SENSORID INTO ast FROM CHECKINOUT group by CHECKINOUT.USERID, CHECKINOUT.CHECKTIME, CHECKINOUT.CHECKTYPE, CHECKINOUT.VERIFYCODE, CHECKINOUT.SENSORID, format(checkinout.checktime,""m/d/yyyy"")",confile

Hope, anyone here can help. Thanks in advance.

[rory]

Hi, for starters put a space inbetween this ..

rs22.open "SELECT
............^