User Profile

Ed Pisa · Dec 8 '10, 07:33 PM

Thank you everyone for your help I have figured out the problem.

I needed to add the following code

Code:

ds.Tables(0).Rows.Add(dr)
                cb = New OleDb.OleDbCommandBuilder(oAdapter)

                [B][I]cb.QuotePrefix = "["
                cb.QuoteSuffix = "]"[/I][/B]

                oAdapter.InsertCommand = cb.GetInsertCommand()

...

Ed Pisa · Dec 7 '10, 02:20 AM

I have a form in access but the problem is the staff that uses it is not the most technically inclined. Through their clicking it was managed to delete an entire column and lost alot of information. I know that you can sent permissions and what not but I thought by creating an easy to use interface through visual studio 2010 it would help the end user. Thanks for your reply I am just going to have to try try again.

Ed Pisa · Dec 7 '10, 02:17 AM

Thanks for the advice I will have to try it first thing tomorrow since it is on my desktop at work.

Ed Pisa · Dec 6 '10, 05:57 PM

Thanks for the reply. I am using the Oledbcommandbui lder. I think I am just incredibly lost at this point. I am very new to all of this and I have been following several different guides to accomplish my task. I am so close to finishing as it does everything but insert a new record. Do you have any suggestions on a better way to insert a new record that would get rid of this syntax error?

User Profile

Profile Sidebar

Leave a comment:

Leave a comment:

Leave a comment:

Dataset insert into access database insert into Syntax error

Leave a comment:

Insert Command Syntax Error