Cannot find tables

5 pts.
Tags:
Microsoft Access
Microsoft Access tables
I am working with a ms access file. When I look at the objects in the access objects window using a category of "object type" I only see one table, when I use the category "Tables and views" I see three tables, these extra two tables are in the dropdown list if you try to create a new relationship. I do not understand where these tables are and why I do not see them using category "object type"
ASKED: October 12, 2012  6:16 PM
UPDATED: October 12, 2012  6:34 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

In my own perecption I think the other two tables have been hidden in the group of Tables( Under object Type category) Because you have indicated that when you try to create a relationship the two tables which was missing appears in the drop down list, I guess I got you right.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • philpl1jb
    It soulds like you have one table and two views.   The views present data from one or more tables, they may limit the columns and or rows from the table or summarize the data.  You should be able to recognize that the view data is similar to the table data because it is the table data.  Once views are created they can be used in making reports, queries, forms. 
    48,545 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following