TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
tjordan
NA
1
0
Insert data into ms access using asp.net
Nov 16 2004 12:21 PM
Here is the code I am using to try to input responses included in dynamic text boxes into an access database: 'Dim myInsertQuery As String 'myInsertQuery = "INSERT INTO tblTestQues (Answer) Values ('22');" 'Dim myCommand2 As New OleDbCommand(myInsertQuery) 'myCommand2.Connection = MyConnection 'MyConnection.Open() 'myCommand2.ExecuteNonQuery() 'myCommand2.Connection.Close() I keep getting the error: System.Data.OleDb.OleDbException: Operation must use an updateable query. My access database is a read only file. I'm guessing this might be the problem. I do not know how to correct this. Any suggestions. Thanks in advanced. Or does anyone know of another method i can use to put info from text boxes into a database.
Reply
Answers (
1
)
Dropdown lists
updating data displayed vertically