ADODB Error - "Cannot update. Database or object is read-only."

[Paul Ked]

Hi all

I'm getting the above error on a new PC I'm setting up, it doesn't happen with the other PC's in use with the same code!

    With CreateObject("ADODB.Connection")
        .Open "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=K:\KKDB.accdb;"
        .Execute "INSERT INTO TestOpen (TestField) VALUES ('" & Sett.Cells(42, 2) & "') "
        .Execute "DROP TABLE Goodsbackup;"
        .Execute "SELECT * INTO GoodsBackup FROM Goods"
        .Execute "DELETE FROM Goods;"
[COLOR=#ff0000]        .Execute "INSERT INTO Goods SELECT * FROM [Excel 8.0;HDR=YES;DATABASE=" & ThisWorkbook.Name & "].[DBGoods$]"
[/COLOR]        .Close
    End With

The 'read-only' error occurs on the line in red, but everything before it executes without error.

Any ideas?

Best regards

Paul Ked

 

[Paul Ked]

Bump...

 

[Paul Ked]

X posted here http://www.vbaexpress.com/forum/sho...se-or-object-is-read-only&p=396397#post396397 reason - no response