Geeks With Blogs
AzamSharp Some day I will know everything. I hope that day never comes.
Talk about errors while doing a simple insert in Access Database. And the surprising thing is that you will never know what the error means since the error message is pointless. Yesterday I was executing an insert statement and keep on getting “ERROR IN THE INSERT STATEMENT”. Now I am not a psychic who can find the reason of this error by simply reading the line above but my friend google is. I found out that I was using a reserved keyword of Access, DATE. I changed my column name and it worked fine. You can also try putting square brackets around the column name like this [DATE] and it might work. Also when you are inserting always remember to send the data in the same sequence as the columns exists in the table or else you will get errors. Posted on Friday, August 5, 2005 8:22 AM | Back to top

Comments on this post: Inserting Data in Access Database

No comments posted yet.
Your comment:
 (will show your gravatar)

Copyright © Mohammad Azam | Powered by: