s_GUID Field

[T''Kai]

Hello Everyone,

I created have a non-replicated database, but at some point it must of been
replicated because I have the s_GUID field in many tables (no all of them). I
have a few times over the last year created a new database and imported all
the tables (as is s_GUID field included). My question is why when I create a
new table sometime (not always) Access will add the s_GUID field to this new
table.

I am absolutely certain that the new database is not replicated.

Any help would be appreciated.

Thank you,

Totally Confused

 

[Chris O'C via AccessMonster.com]

If you import replicated tables into a new db file, the db isn't replicated
but the imported tables will retain the s_GUID, s_Lineage, etc columns. If
you create new tables by copying the structure of these tables or by using
make table queries that use a SELECT tablename.*, the new tables will have
the s_GUID, s_Lineage, etc columns too. If you create a new table with the
GUI, it won't automatically have the s_GUID, s_Lineage, etc columns.

If you don't want to see the s_GUID, s_Lineage, etc columns in your existing
tables, delete those columns and compact the db. It'll be smaller without
those columns.

Chris
Microsoft MVP