Updating Data in MSysQueries Table.

[Guest]

Is there any way to update the data in this table. I have a bunch of pass
through queries where I need to update the ODBC connection to point to a
different Sybase database. Instead of updating the properties in each query
individually, is there any way to do an update to that data in the
MSysQueries table.

Thanks,
Kevin

 

[Michel Walsh]

Hi,


Even if there was one to do it, it is one of the thing that is better
described as "You don't want to do that", since this is a working table
maintained by Jet, and your modification would likely corrupt the data of
the whole database. Use the standard SQL declaration language, or DAO or ADO
to (indirectly) modify the system tables.


Hoping it may help,
Vanderghast, Access MVP

 

[Marshall Barton]

Is there any way to update the data in this table. I have a bunch of pass
through queries where I need to update the ODBC connection to point to a
different Sybase database. Instead of updating the properties in each query
individually, is there any way to do an update to that data in the
MSysQueries table.

No! The MSys tables are system table and are read only.
Just imagine the chaos that would ensue if you made a
mistake updating them.

 

[John Vinson]

Is there any way to update the data in this table. I have a bunch of pass
through queries where I need to update the ODBC connection to point to a
different Sybase database. Instead of updating the properties in each query
individually, is there any way to do an update to that data in the
MSysQueries table.

Thanks,
Kevin

You can use VBA code to loop through the Queryedef's collection and
update each one's Connect property - but as noted, DON'T try to do it
directly in MSysQueries. That way madness lies!

John W. Vinson[MVP]