I posted this is in the wrong forum before (twice!)... sorry!
Here's the message...
I'm very new to asp.net and web programming in general but I've made some progress in the last few days but am currently struggling with an error I cant get past.
I'm using Windows XP and Dreamweaver. I've got an MS Access database and I've created the connection to it in Dreamweaver successfully. I'm using the ASP.net VB
In Dreamweaver I've made a couple of pages and in one of them I've added a dataview object (sorry if my terminology isnt correct). I've opened the page in IE and it's worked fine (displayed all the records from the database table).
However, when I added a 'insert record' object it prompts me to enter the new record but then I get this error...
System.Data.OleDb.OleDbException: Operation must use an updateable query.
at System.Data.OleDb.OleDbCommand.ExecuteCommandTextE rrorHandling(Int32 hr)
at System.Data.OleDb.OleDbCommand.ExecuteCommandTextF orSingleResult(tagDBPARAMS dbParams, Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteCommandText( Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteCommand(Comm andBehavior behavior, Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteReaderIntern al(CommandBehavior behavior, String method)
I've trawled the forums and mostly they mention read/write privileges. I'm not exactly sure how to add these (or if indeed this is the problem) but this is what I've done;
control panel - administrative tools - Internet Information Services
added ticks in read and write to all the folders. it was set to 'scripts only' which i've heard is correct.
I've also tried to make the database not read only and the folder it's in. I've noticed that the read only 'tick' has a habit of returning though.
I tried for a few hours yesterday to get past this prob, any help would be appreciated!