Forum home » Delegate support and help forum » Microsoft Access Training and help » Query using Mysysqueries and/or Mysysobjects

Query using Mysysqueries and/or Mysysobjects

ResolvedVersion 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:

Splittng a database

Split your database into two (at least).

Keep all of your code, forms, reports, etc. in one 'code' database and all of your tables in another 'data' database which is then linked to the 'code' database.

This makes modifications, updates and back-ups that much easier and allows you to work on a new version of your 'code' database without affecting existing users. It also makes it easier should you wish to convert a single user databases into a multi-user networked version.

View all Access hints and tips

Query using Mysysqueries and/or Mysysobjects

Query using Mysysqueries and/or Mysysobjects

RE: Query using Mysysqueries and/or Mysysobjects

Access articles

Access tip:

Splittng a database