Query using Mysysqueries and/or Mysysobjects | Access forum

Resolved · Medium Priority · Version 2003

Fri 14 Oct 2011, 16:58 Delegate Jamie said...

Jamie has attended:
Access Intermediate course
Access Advanced course
Access VBA course

Query using Mysysqueries and/or Mysysobjects

What query statement using Mysysqueries and/or Mysysobjects could be used to list all action queries in a database together with their type ('append', 'update', etc.) and the main table(s) on which the action is carried out?
- Thanks

Tue 18 Oct 2011, 07:17 Trainer Anthony said...

RE: Query using Mysysqueries and/or Mysysobjects

Hi Jamie, thanks for your query. Some information about using the MSysObjects table can be found here:

http://www.perfectparadigm.com/tip001.html

...but personally I would write a quick subroutine to loop through the querydefs, pull out the required info and then write to a table or text file. It all depends on the situation, however!

Hope this helps,

Anthony

Mon 24 Oct 2011: Automatically marked as resolved.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Access tip:

Hiding Multiple Table columns

If you want to hide non-adjacent Access table columns. In Datasheet view, open the table that contains the columns you want to hide.

On the Format menu, click Unhide Columns.
In the Unhide Columns dialog box, clear the check box next to the name of each column you want to hide.
Click Close.

This method makes having to use the Hide Columns command repeatedly unnecessary

View all Access hints and tips