locked
Table has different field captions in front-end and back-end. RRS feed

  • Question

  • Linked front-end and back-end.

    Design view on table shows different field  captions in front-end and back-end.

    How is this possible?

    Access 2010.

    Also, Access says I can't make changes to table properties from the front-end, but I can change the captions and they do change.

    Wednesday, October 3, 2018 4:25 PM

Answers

  • Field captions are stored in the table definition (TableDef), even if it's a linked table.  It appears that the field captions in the front-end -- both in datasheet view and in design view -- are a merger of the captions specified in the back-end and the captions specified in the front-end, with the front-end captions overriding the back-end.

    Despite what the message says when you open a linked table in design view, it's only most, not all, of the properties that can't be changed.  In earlier versions, the message used to say that "some properties can't be modified".  Now the message says the "design can't be modified", but the facts haven't actually changed.  For example, you've always been able to set a table's OrderBy and Filter properties in the front-end.


    Dirk Goldgar, MS Access MVP
    Access tips: www.datagnostics.com/tips.html

    Wednesday, October 3, 2018 7:53 PM

All replies

  • Hello, 

    How is this possible?

    Sorry, what you understand under Caption for back-end?

    If there are two part of GUI - there are used two separate grid - each grid can be configured differently. If grid against table - the same - grid configured independently.

    This in addition to SELECT A AS B option.


    Sincerely, Highly skilled coding monkey.

    Wednesday, October 3, 2018 7:50 PM
  • Field captions are stored in the table definition (TableDef), even if it's a linked table.  It appears that the field captions in the front-end -- both in datasheet view and in design view -- are a merger of the captions specified in the back-end and the captions specified in the front-end, with the front-end captions overriding the back-end.

    Despite what the message says when you open a linked table in design view, it's only most, not all, of the properties that can't be changed.  In earlier versions, the message used to say that "some properties can't be modified".  Now the message says the "design can't be modified", but the facts haven't actually changed.  For example, you've always been able to set a table's OrderBy and Filter properties in the front-end.


    Dirk Goldgar, MS Access MVP
    Access tips: www.datagnostics.com/tips.html

    Wednesday, October 3, 2018 7:53 PM