SQL TROUBLES

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Because my data is geting close to the 1.5 Gigs I thought it would be a good
idea to upsize the access program to SQL. I am having a hard time with
smallest of codes. I need to open a form by VBA I send the where statement eg
ContactID = 452 And Dateofvisit = #12/26/2006# I get the error " Invalid SQL
statement Check the server filter on the form record source. " This was
working fine in Access but it just wont work in SQL what am I doing wrong ?

Thanks In Advance
 
SQL Server uses ' as a delimiter for dates, not #. As well, you might want
to use ContactID = 452 And Dateofvisit = '2006-12-26'
 
Thankyou Doug If they pay you, You are worth every penny. Where or what book
can I buy that I can use as a reference for such problems as this syntax.
 
Back
Top