After adding 5 new fields to a table in a replicated design master database, Access is replacing the display of 2 fields with "system replication" fields. These 2 fields are prefixed with "Gen_", have a data type of Number and relate to two memo fields present in the table. If I query SELECT Master.* FROM Master; all the 5 new fields are shown, but they are replaced with the "Gen_" fields if selecting by field. Does anyone have any idea what is going on?
Jenno wrote in news:40e80b30-d130-46eb-85d9-ca5781a29476@a70g2000hsh.googlegroups.co m: > After adding 5 new fields to a table in a replicated design master > database, Access is replacing the display of 2 fields with "system > replication" fields. These 2 fields are prefixed with "Gen_", > have a data type of Number and relate to two memo fields present > in the table. > > If I query SELECT Master.* FROM Master; all the 5 new fields are > shown, but they are replaced with the "Gen_" fields if selecting > by field. > > Does anyone have any idea what is going on? You added memo fields. For each memo field in a replicated table, there is a Gen_ field that tracks the changes to the memo fields. This is because memo data is not stored in the record itself, but somewhere else in the data file (the only thing that's stored in the record for the memo field is the pointer to the location of the memo data). This is absolutely standard for all replicated tables with memo fields. If you find the location of them annoying, in table design in your Design Master, move them to the end of the table. But that oughtn't really matter. -- David W. Fenton http://www.dfenton.com/ usenet at dfenton dot com http://www.dfenton.com/DFA/
Thank you for your response and clear explanation. I get the principle of the Gen prefix for memo fields. My real issue is that of the 5 new fields I added (all Yes/No data type), 2 are now not displayed but have been replaced by Gen prefixed fields representing previously existing memo fields. I cannot see these 2 new fields in either design or datasheet view. Any further thoughts on whats happening?
Jenno wrote in news:beaa2fc6-08fe-4ff6-9fa8-8af9b4a73acd@k30g2000hse.googlegroups.co m: > Thank you for your response and clear explanation. I get the > principle of the Gen prefix for memo fields. > > My real issue is that of the 5 new fields I added (all Yes/No data > type), 2 are now not displayed but have been replaced by Gen > prefixed fields representing previously existing memo fields. I > cannot see these 2 new fields in either design or datasheet view. > > Any further thoughts on whats happening? In datasheet view, have you gone to the FORMAT menu and looked at the HIDE COLUMNS list? I'm not sure why there'd be issues in table design view, though. Do you have SHOW HIDDEN and SHOW SYSTEM objects turned on? -- David W. Fenton http://www.dfenton.com/ usenet at dfenton dot com http://www.dfenton.com/DFA/
On Jun 18, 1:03 pm, "David W. Fenton" <XXXuse...@dfenton.com.invalid> wrote: > Jenno wrote innews:beaa2fc6-08fe-4ff6-9fa8-8af9b4a73acd@k30g2000hse.googlegroups.co > m: > > > Thank you for your response and clear explanation. I get the > > principle of the Gen prefix for memo fields. > > > My real issue is that of the 5 new fields I added (all Yes/No data > > type), 2 are now not displayed but have been replaced by Gen > > prefixed fields representing previously existing memo fields. I > > cannot see these 2 new fields in either design or datasheet view. > > > Any further thoughts on whats happening? > > In datasheet view, have you gone to the FORMAT menu and looked at > the HIDE COLUMNS list? I'm not sure why there'd be issues in table > design view, though. Do you have SHOW HIDDEN and SHOW SYSTEM objects > turned on? > > -- > David W. Fenton http://www.dfenton.com> usenet at dfenton dot com http://www.dfenton.com/DFA/ Thanks for the suggestion. The columns are not hidden and the SHOW HIDDEN and SHOW SYSTEM objects are both enabled. I ran a documenter analysis on the table and all 5 of my new fields appear there! Running out of ideas and time on this one.
