----------------------------------------------------------- New Message on MumbaiUserGroup
----------------------------------------------------------- From: rahulvb Message 1 in Discussion Hi, I have the following query for Access 2000 backend UPDATE MatChallan SET SuppId=13,ChallaDate='08/05/2004 10:14:19 AM',SuppChNo=' ',SuppChDate='07/30/2004',VehicleNo='MH-15 G-106',UserId=1,ClientId=2,SiteId=2,DFlag='T',InvNo=26,VSize=' ',EntryDate='08/05/2004',Rem1=Null,Rem2=Null,Rem3=Null WHERE refid = 94 If executed from VB with connection object it gives error saying "Syntax error in string in query expression" But if the same query is executed from access - query wizard it is running perfectly fine. Can anyone suggest what might be the problem. Thanks. Rahul. ----------------------------------------------------------- To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. http://groups.msn.com/MumbaiUserGroup/_emailsettings.msnw Need help? If you've forgotten your password, please go to Passport Member Services. http://groups.msn.com/_passportredir.msnw?ppmprop=help For other questions or feedback, go to our Contact Us page. http://groups.msn.com/contact If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. mailto:[EMAIL PROTECTED]
