请教高手,这句SQL语句为什么在vb中不能以ADO的方式执行呢?但它可以在ACCESS中执行!Select Address,BankNumber,Birthday,City,Costcode,Department,DepartmentID,DetailInfo,FileLocation,HighDegree,HuKou,IDNumber,IsSelected,JoinDate,LastWorkingDate,Left,Marriage,Mobile,Name,NativePlace,OtherName,Pager,PassportNumber,PayMethod,Photo,PolityName,Positions,Postcode,ProbationDate,Race,Rank,Region,Section,SeparaCompany,SeparaType,Sex,StaffNO,StaffType,TaxedCity,TecDate,TecPosition,Tel,WorkDate,WorkID,YearlyLeaveLimit
From Qry_newstaff Where JoinDate Between #2005-03-01# And #2005-03-31#
From Qry_newstaff Where JoinDate Between #2005-03-01# And #2005-03-31#
Unspecified error"
取消ADO的引用,安装VBSP5,再重新引用ADO
如果沒錯,可能又是用了什麽保留字了