System.Data.OleDb.OleDbException: Operation must use an updateable query ACE.OLEDB.12.0

Asked Dec 02 '17 at 22:04

Active Dec 02 '17 at 22:04

Viewed 226 times

Why I have the exception in VS2017 when I am trying to update a table OleDbConnection("Provider = Microsoft.ACE.OLEDB.12.0; Data Source = database.accdb; Persist Security Info=False;"

"UPDATE `Cars` SET `company` = (SELECT `id` FROM `Companies` WHERE `Companies`.`company` = parameter_company) WHERE `id` = parameter_id"

asked Dec 02 '17 at 22:04

Mike Waters

Did you try to run that query through the MS-Access query processor interface? – Steve Dec 02 '17 at 22:08
Does C# require the apostrophes for field names? Try without. – June7 Dec 02 '17 at 23:10

System.Data.OleDb.OleDbException: Operation must use an updateable query ACE.OLEDB.12.0

0 Answers0