|
I am dealing with a legacy VB6 app that has an Access backend. The db contains a linked table.
I need to be able to edit the field (MSysObjects.Database) that contains the location of the database that contains the table that is linked to. I am able to open a connection, create the required recordset but I have not succeeded in updating the record.
I receive the following error message: "Operation must use an updateable query". In the db I have gone to Tools | Security | User and Group Permissions and set the permissions for MSysObjects to allow read/write etc.
Any suggestions or other options for changing the value of the location of the linked table in the MSysObjects table?
| 
