dlord54
asked on
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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 "~*"
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 "~*"
ASKER