Updating Data in MSysQueries Table.

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
Kevin7470 said:
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.
Click to expand...


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.
 
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
Click to expand...

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]
 
Back
Top