aprilleec76
New member
- Local time
- Today, 08:53
- Joined
- Mar 15, 2014
- Messages
- 4
i am working in a 1997 database that was recently converted to 2003---which we are viewing in 2010 in compatibility mode.
I have these three fields in one of our main tables (client table) from when the database was replicated
When you replicate a database, Microsoft Access adds the following system fields to each replicated table in the replicated database:
FIELD DESCRIPTION
s_GUID A globally unique identifier for each record.
s_Lineage A binary field that contains information about the history of changes to each record.
s_Generation A field that stores information regarding groups of changes.
They are all indexed. Do S_Lineage and S_Generation have to be indexed? I'm getting an error message when i try to add indexes to other fields that there are too many indexes already?
thanks a ton
I have these three fields in one of our main tables (client table) from when the database was replicated
When you replicate a database, Microsoft Access adds the following system fields to each replicated table in the replicated database:
FIELD DESCRIPTION
s_GUID A globally unique identifier for each record.
s_Lineage A binary field that contains information about the history of changes to each record.
s_Generation A field that stores information regarding groups of changes.
They are all indexed. Do S_Lineage and S_Generation have to be indexed? I'm getting an error message when i try to add indexes to other fields that there are too many indexes already?
thanks a ton
