Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

MSYS Tables

Status
Not open for further replies.

MrM121

Programmer
Aug 21, 2003
83
GB
Does anyone know how to make these tables updateable? I need to be able to use an update query on the msysqueries table.

Thanks,

Nick
 
Nick,
I don't think you can do that. Those are bound system objects, and MS hangs on pretty tightly.

Pretty much anything you would ever want to do to a query (like rename it, copy it, change the SQL, create a new query on the fly, whatever), you can do in a module with the querydef object.

Tranman
 
I guess I will just have to do that then.

Thanks for your help,

Nick
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top