ADP: Where is msysobjects info stored?
Posted on 2003-03-12
SQL Server 2000
I am creating a Microsoft Access project (ADP) file where all the data is stored on a back-end SQL Server (2000, not MSDE). I want to generate a list of all the forms or all the reports to populate a combo box. I know how to do it in an MDB database (msysobjects table), but I can't find where Access stores the info in an ADP environment.
(Is it possible it is stored in the CurrentProject.AllForms collection? If so, where is it persisted when the database is closed?)
Where is this info stored, and what would the code be to populated a combo box with the names of all the reports in my project?