locked
ms access 2010 services template. Cannot see design view RRS feed

  • Question

  • I cannot see design view for forms or tables in the Services template ms access 2010. 

    in access options/options/current database/  the tick boxes (enable layout view & enable design changes for tables in Datasheet view)  are both greyed out.

    My question is. How can I get into the tables in design mode? (This has only happened with the Services Template for Small Business)

     

     

    Thursday, March 10, 2011 3:49 PM

All replies

  • Hi,

    To get into the tables in design mode, from the left panel, under objects, right click the table, and choose Design View.

    If you are still unable to enable the design view, the database might be read-only.

    Best Regards,

    Sally Tang

    Monday, March 14, 2011 8:13 AM
  • Hi Sally,

    Thanks for your reply. I need to get into design view to add fields to the template tables and forms,  however as you say it looks like they are read-only. (The table icon has a small globe in the middle which I assume means read-only.)  If I create my own table or form I get into design without a problem. My question is therefore, is there a way I remove the read-only option from the template tables?  Or is this a restriction on the "Services" template that the tables cannot be changed.

    Kind Regards,

    Findlay 

     


    Findlay
    Monday, March 14, 2011 10:04 AM
  • I am also having this problem with this template. I've been searching, but cannot find any info on how to make a table "non read-only" in MSAccess 2010, if in deed that is the case for this database.

    The template can be found here: http://office.microsoft.com/en-us/templates/CL102207655.aspx?av=my#ai:TC102489834|

    Thanks,

    • Proposed as answer by ian.ball Monday, June 6, 2011 3:42 PM
    • Unproposed as answer by ian.ball Monday, June 6, 2011 3:42 PM
    Tuesday, May 3, 2011 5:02 PM
  • Update:

    Finally figured out that this template is a "web database" which is edited differently:

    http://office.microsoft.com/en-us/access-help/build-an-access-database-to-share-on-the-web-HA010356866.aspx#_Toc262737242

    • Proposed as answer by ian.ball Monday, June 6, 2011 3:45 PM
    Monday, June 6, 2011 3:45 PM
  • Is there any way to export these web-based/read-only forms or macros to another database?

    • Proposed as answer by Thetank256 Wednesday, October 10, 2012 2:42 AM
    • Unproposed as answer by Thetank256 Wednesday, October 10, 2012 2:42 AM
    Sunday, June 17, 2012 3:11 AM
  • check this link this may help

    http://office.microsoft.com/en-us/access-help/introduction-to-the-access-2010-templates-HA010341734.aspx

    Tuesday, June 19, 2012 5:26 AM