Susanhopes
Technical User
A field in our main table has suddenly disappeared. It no longer shows in the design list, or in any other field list in queries, etc. But strangely, the correct data does show when viewing the field in a form. Design view/properties claims that the control is invalid, yet ghosts of my data seem to exist.
My best backup is two weeks old, and one user has made some changes since then. Nothing that can't be done again, but a pain. Also, I just don't like this situation existing at all.
The database is replicated. My best guess is that, during a recent swap of the location of the Master to the office where I was in residence for a week, then back again to my regular location, something happened. New GUID etc. fields are showing in that table. Did I reach my max number of fields, and the last two (turns out another is gone as well) were written over by the replication guides?
Better still, how is it that the data exists in some views and not in others? Where is this ghost data living? I've repaired and compacted to no avail. Have not tried changing data in that field b/c didn't know if it would lose its grip entirely. Did one of the new replications converted to a Master become corrupted? Would appreciate any help available. TIA,
Susan
My best backup is two weeks old, and one user has made some changes since then. Nothing that can't be done again, but a pain. Also, I just don't like this situation existing at all.
The database is replicated. My best guess is that, during a recent swap of the location of the Master to the office where I was in residence for a week, then back again to my regular location, something happened. New GUID etc. fields are showing in that table. Did I reach my max number of fields, and the last two (turns out another is gone as well) were written over by the replication guides?
Better still, how is it that the data exists in some views and not in others? Where is this ghost data living? I've repaired and compacted to no avail. Have not tried changing data in that field b/c didn't know if it would lose its grip entirely. Did one of the new replications converted to a Master become corrupted? Would appreciate any help available. TIA,
Susan