Error: Operation must use an updateable query

[Scally84]

Hi,

I'm using a Microsoft Access database to store some data. Now I'm trying to insert some new data into this database. This is how my source code looks like:

InsertFormQuery = "INSERT INTO FILE_UPLOAD ( " & _
                                 "FILE_ID, FILE_NAME, FILE_DESC, FILE_FLAG , " & _
                                 "DATE_UPLOADED, URL, DEPT, SUB_DEPT, USERNAME) " & _
                                 "VALUES( " & _
                                 intID & ", " & _
                                 "'" & Replace(FileName, "'", "''") & "', " & _
                                 "'" & Replace(FileDesc, "'", "''") & "', " & _
                                 "'" & FILE_FLAG & "', " & _
                                 "'" & datum & "', " & _
                                 "'" & FileURL & "', " & _
                                 "'" & EL_DEPT & "', " & _
                                 "'" & Session("Dept") & "', " & _
                                 "'" & fusername & "')"        

                              
                              objCommand = new OleDbCommand(InsertFormQuery, objConnection)
                              
                              objCommand.ExecuteNonQuery()

Now when I run this code it works fine, on my local computer. But when I upload this code to a test server I get this error: "System.Data.OleDb.OleDbException: Operation must use an updateable query". I've looked up this error and found the following description: This error is typically encountered when your script attempts to perform an UPDATE or some other action that alters the information in the database. This error occurs because ADO is unable to write to the database. Does someone know a way to solve this problem?

Thanks

 

[vbkris]

the .mdb file must have read /write permissions on the server...

Known is handfull, Unknown is worldfull