I have created several databases in Access 2003 and our company has upgraded to Access 2010. When I open the databases, it does not have an option to view tables. I simply want to view tables/queries, etc....how do I get to that point?
I have created several databases in Access 2003 and our company has upgraded to Access 2010. When I open the databases, it does not have an option to view tables. I simply want to view tables/queries, etc....how do I get to that point?
After opening the database, go under File-->Options and then select Current Database along the left pane of the window. Under Navigation, click on the box next to Display Navigation Pane & then click on the OK button. Go to the Home tab, the Navigation pane will be along the left. You may have to click the >> to expand the pane to see the objects.
If you have any issues, you may have to go back to the File-->Options-->Current Database-->Navigation and click the button to adjust settings
THANK YOU, THANK YOU, THANK YOU!!! This was driving me crazy!!
You're welcome. Microsoft did change a lot of things when they moved away from the 2003 version!