view tables and queries in access 2010 runtime

I am new to Access 2010. I am a little familiar with the ribbons that can be created but is there a way to allow the user to see the tables and queries similar to the navigation pane when you create a runtime version?
dlord54Asked:
Who is Participating?
 
peter57rCommented:
Not in the navigation pane.

You have to build such a list if you want the users to see it.

You can use queries based on msysobjects table to get a list of tables and/or queries and create listboxes or comboboxes from such queries.

Tables...

Select [Name] from msysobjects where type = 1 and [name] not like "msys*" and [name] not like "f_*"
0
 
datAdrenalineCommented:
You can create a Form object the lists the tables in a List Box control.  You can integrate the Query objects into the same List Box, or create another one.

But ... what is your intent in providing this capability?  If its to provide acces to the data that is presented via the Queries, or the data that is stored in the Tables, then the path for doing that is to create Form objects that expose that data to the user.
0
 
dlord54Author Commented:
Thanks for your help. I now know the direction that I need to take.
0
 
datAdrenalineCommented:
FYI ...

Tables ...

Select [Name] from msysobjects where type In (1,4,6) and [name] not like "msys*" and [name] not like "USys*"

Queries ...
Select [Name] from msysobjects where type = 5 and [name] not like "~*"
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.