Access objects within a 2nd database

[MSAccessUser]

Any ideas on how I can get a list of the names of the queries and tables within a different database?

For example, from db1 I want to get a list of the names of the queries and tables within db2.

Thanks!

 

[Sergeant]

Here's a starting point:
MSysObjects
(Container for all system objects...tables, queries, forms, etc...)

 

[MSAccessUser]

I'm sorry I couldn't take advantage of your hint. Can you please elaborate?

I was able to do it for the tables and queries by setting a reference by using the OpenDatabase command and the TableDefs.Name and QueryDefs.Name but can't do it for the forms and the reports.

Can you show me how I can use MSysObjects to access the names for the forms and reports?

Thanks

 

[Sergeant]

See this post...
http://www.access-programmers.co.uk/forums/showthread.php?t=99146&highlight=msysobjects