Thanks for the suggest. I managed to solve this last night - my stupidity: The column in the ACCESS database was named"Date" but it seems that "Date" is verboten even within the protected confines of a command query.
I changed the column name to "InvDate" and lo and behold it all worked out...
I'm not sure if I'm missing something here.
I'm tring to update the "Date" field in a record in an ACCESS database, using a form I designed in vb.net.
Everything else works fine but as soon as I try to send the date to the access form, I get an error saying there is a Syntax error in UPDATE...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.