dave 0

dave 0

  • NA
  • 5
  • 0

Ms Access Syntax Error in Update Statement

Jul 13 2004 4:08 PM
I can connect to my Access database and read records from it but when I try to update the database I get "Syntax error in Update statement". I get the same for Insert and Delete. I have checked the synatx by running the statement in Access itself and there it works fine. I've tried various ways to create my statements in .net and I've checked my permissions in Access. I can't see what is wrong. Has anyone come across this before? I feel there is a simple solution as I'm not trying to do anything complicated. Hope you can help. Dave

Answers (6)