How do I add Msysobjects table to the Access 2000 query builder?

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

Guest

I used it so long ago I've forgotten how I did it and I hope someone can help.

I used Msysobjects table to list the names of reprots, queries and tables in
a list box, so users can use them to create additional reports and queries.
 
Create a query based on Msysobjects. Filter out the objects by the Type
column.

e.g. Forms = -32768
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Get Table name for a query from form 1
Query within a report 1
Pass to Query 2
Cannot access foreign database Msysobjects - No read rights 2
How to add linked tables objects to this access query output? 0
query to retrieve list of field names belonging to an access table 3
How do I display MSysObjects? 4
query - express builder 9

Back
Top