Runs fine in MS Access directly ,..but if i execute it from ASP it gives error as

Error Type:
(0x80004005)
Unspecified error

SELECT tm.TeamName,wt.WTName,ts.Projid,ts.task,task.descn ,at.ActName,ts.workdate,ts.time_hr,ts.time_mi FROM timesheet ts,WorkType wt,ActivityMaster at,TeamMaster tm,timeestmaster task WHERE ts.teamid = tm.teamid and ts.wtid = wt.wtid and ts.actid = at.actid and ts.projid = task.proid and ts.task = task.task and ts.empid = 13979 and ts.workdate between #1-Aug-2006# and #7-Aug-2006#
I have heard if we use reserved words it will generate such error but here i can't see any such errors...any idea??

Rupen Anjaria.:)
------------------
We CAN'T avoid problems, but can solve it.

'at' is a reserved Keyword; also, that is not a very optimized query, i'd suggest using JOINS as opposed to just selecting from those tables.

"The one language all programmers understand is profanity."

Thanks...it is working now...
further there r around 5 tables i have to join and i dont know how to do this by JOINS...can u suggest...Thanks in advance..


Rupen Anjaria.:)
------------------
We CAN'T avoid problems, but can solve it.