Share via

only datasheet view available

Anonymous
2010-09-23T05:53:17+00:00

I just installed Office Professional Plus 2010, and, in Access, only the datasheet view is available.  I click on "View" on the "Home" tab" and only the datasheet view is available, and I double-click on a table, then right-click on the tab, and only the datasheet view is available as a choice (not the layout and design views).  Also (and I have no idea if this is a related issue) "Relationships" on the "Table Tools" tab is greyed out.  I need both of these to finish work on a many-to-many relationship between two tables and a junction table (I'm trying to set up the primary key in the junction table).  HELP!!!!!!  Thanks, Kerry

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

12 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2010-09-23T06:04:14+00:00

    Well, I did some hunting around and found the solution: in the Navigation Pane, I single-clicked on table I wanted to open in design (or layout) view, then I clicked on the "Create" tab and I clicked on "Form", and, poof, there were all the attributes of design and layout views that I could hope to use.  I will say, though, that the "Relationships" control under the "Database Tools" is still greyed out -- I'll try to scare up the solution to that mystery, too, but, if someone out there wants to save me the legwork, I sure would appreciate it.  Cheers, Kerry

    2 people found this answer helpful.
    0 comments
  2. Anonymous
    2011-03-14T17:28:56+00:00

    Opening a form enabled the datasheet view option for me but I still have no design mode and relationships is still greyed out. Incidently this only happens in the downloaded "Goods" template database I got from the file/open section.

    0 comments
  3. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more

  4. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more

  5. ScottGem 68,810 Reputation points Volunteer Moderator
    2010-09-23T12:34:07+00:00

    Right click on the selected table in the Nav pane and select Design View

    Hope this helps, Scott<> P.S. Please post a response to let us know whether our answer helped or not. Microsoft Access MVP 2009 Author: Microsoft Office Access 2007 VBA Technical Editor for: Special Edition Using Microsoft Access 2007 and Access 2007 Forms, Reports and Queries

    0 comments