none
Why does Access '16 delete table Order By and Filter properties when editing table design? RRS feed

  • Question

  • Maybe it's always been this way and I've never figured out it was happening, but Access '16 deletes Table properties Order By and Filter whenever editing the design of the table. It's incredibly annoying. Is there a workaround? Anybody know a reason for this behavior?
    Monday, July 4, 2016 7:10 PM

Answers

  • Hi Dick Watson,

    Access removes the orderby and filters when you modify the table design.

    because it is possible that you had deleted the field or modified that field on which you had set filters or group by.

    so if access continues to keep it then when you open the table next time then the field will not be available there to filter or for orderby at that it will creates an error and you will get stuck their.

    many other reasons are also can be there for this behavior of Access but I just informed you about very common reason.

    so Access don't want to generate any kind of error by itself that's why it removes the filter and orderby.

    hope this will help you to understand.

    Regards

    Deepak 


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    Tuesday, July 5, 2016 1:26 AM
    Moderator

All replies

  • Hi Dick Watson,

    Access removes the orderby and filters when you modify the table design.

    because it is possible that you had deleted the field or modified that field on which you had set filters or group by.

    so if access continues to keep it then when you open the table next time then the field will not be available there to filter or for orderby at that it will creates an error and you will get stuck their.

    many other reasons are also can be there for this behavior of Access but I just informed you about very common reason.

    so Access don't want to generate any kind of error by itself that's why it removes the filter and orderby.

    hope this will help you to understand.

    Regards

    Deepak 


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    Tuesday, July 5, 2016 1:26 AM
    Moderator
  • Access removes the orderby and filters when you modify the table design. because it is possible that you had deleted the field or modified that field on which you had set filters or group by.

    The same could be said of record validation, data macros, etc., but those don't get deleted. Anyway, thanks for the reply. At least it's "as designed," such as it is.
    Friday, July 8, 2016 5:08 AM
  • Hi Dick Watson,

    in the original post you had mentioned that ,"It's incredibly annoying."

    if you think that it is not user friendly then you can give your feedback to Access User Voice regarding this issue.

    please visit the link below to give feedback.

    Access User Voice

    Regards

    Deepak


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    Friday, July 8, 2016 8:38 AM
    Moderator