By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,471 Members | 2,264 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,471 IT Pros & Developers. It's quick & easy.

Update field value in MSysObjects

P: 1
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?
Jul 18 '06 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.