I'm getting this error when I'm attempting to update an access database from textboxes. I originally thought the error was because the database was wanting specifically formated data inserted into the tables, but I've taken away all formats, and it is still not accepting the data. Please Help
I've included the project files if anyone wants to take a look and give me feedback.
I haven't looked at your zipped project but just to let you know that I had this same error happen to me just recently and i was stuck on it for quite some time.
The problem in the end was, I was using a reserved word for one of the field names. It didn't look like a reserved word to me and when you see that error, you think there is something wrong with the Select statements which sends you off on a completely different track!
Check all the field names in your table and check your table names while your there.
My first suggestion (without looking at your code) is to execute the update directly in access with test data. This will tell you if your problem is in the update statement, or program logic.
To update: I've tried creating this form using the dataform wizard and I still get the error. It loads the database perfect, but once I try to update the table is when I get the error message
Also, I'm able to delete records that already exist on the table and update with no problem. When I'm adding records to a table and try and update the table then is when I'm getting the error, and I've gone through the database and tried to see any type of errors, and I can't figure it out. If anyone could take the time and look at it, I'm out of ideas when it comes to the problems concerning this. Thanks
Reply With Quote