Share via

cant open my tables in Datasheet view

Anonymous
2016-05-17T21:05:53+00:00

Hi

I am using Access 2010, when I click on my tables to view and change, the DATASHEET TAB does not appear. 

The tutorials show; open in the 'many'view. That is what I need to do, but can't.

Please assist

Regards

Heinrich

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

10 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2016-05-17T21:36:14+00:00

    Hi Scott

    When I click on the table, it does open in Datasheet view. On the ribbon above I only have, Table Tool under tables & tools. The tab for Datasheet is missing.

    3 people found this answer helpful.
    0 comments
  2. Anonymous
    2016-05-17T21:14:08+00:00

    I'm not sure what you mean - do you mean you cannot open the Tables in Datasheet view (i.e. where you can see the data)?

    Are you working with a standard Desktop database, or a Web App?

    3 people found this answer helpful.
    0 comments
  3. Anonymous
    2016-05-17T21:39:28+00:00

    If you click on this microsoft link you will see the tutorial and what I need to do, only that my Datasheet TAB does not appear.

    https://support.office.com/en-us/article/Build-relationships-for-a-new-Access-2007-database-Create-a-relationship-31dcf4de-ba3c-4a00-9f24-7b04c1f6d8ba?ui=en-US&rs=en-US&ad=US

    1 person found this answer helpful.
    0 comments
  4. ScottGem 68,810 Reputation points Volunteer Moderator
    2016-05-17T22:53:26+00:00

    As a general rule you shouldn't be working directly in tables. All interaction between users and table should be done through forms.

    As DBGuy said, you are looking at a 2007 tutorial. The interface is different. I would also not recommend creating relationships that way. Simply open the relationship window show the tables you want to relate, then drag and drop the one side onto the many side.

    0 comments
  5. DBG 11,711 Reputation points Volunteer Moderator
    2016-05-17T22:30:53+00:00

    Hi. Might it have something to do with the tutorial using Access 2007 while you're using Access 2010? In any case, unless you're creating a web app to be published in SharePoint, creating a lookup field using the Lookup Wizard is not really recommended. It's not how you would actually establish table relationships in a desktop application. Just my 2 cents...

    0 comments