Results 1 to 3 of 3
  1. #1
    rebfein's Avatar
    rebfein is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2015
    Location
    So Cal
    Posts
    114

    Table design changes ?

    I created a db starting out with 4 tables and graduating to 9 now.

    Yesterday as I was closing out, Access asked me if I wanted to save the design changes to two of the tables.

    I didn't make any design changes.



    Is Access possessed? I don't understand how this can happen without human intervention.

    Any explanations?

    Thank you for your help.

  2. #2
    John_G is offline VIP
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2011
    Location
    Ottawa, ON (area)
    Posts
    2,615
    You might not have opened the table in design view, but if you just open a table normally and for example sort on a column, set a filter or change a column width, Access will consider that a design change and ask if you want to save it.

  3. #3
    rebfein's Avatar
    rebfein is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2015
    Location
    So Cal
    Posts
    114

    Table Design change

    Thank you John. I'll be more careful about adjustments in the future.

    Reb ecca

    Quote Originally Posted by John_G View Post
    You might not have opened the table in design view, but if you just open a table normally and for example sort on a column, set a filter or change a column width, Access will consider that a design change and ask if you want to save it.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 09-19-2016, 12:03 PM
  2. Replies: 3
    Last Post: 04-27-2014, 08:08 PM
  3. Table Design -- want to avoid a design that creates blank fields
    By snowboarder234 in forum Database Design
    Replies: 4
    Last Post: 10-08-2012, 10:13 AM
  4. Replies: 8
    Last Post: 03-24-2012, 11:03 AM
  5. table design: one big table vs. multiple small tables
    By lstairs in forum Database Design
    Replies: 3
    Last Post: 12-31-2009, 08:46 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums