If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
s_GUID Field
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 |
#2
|
|||
|
|||
s_GUID Field
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 T''Kai wrote: 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 -- Message posted via http://www.accessmonster.com |
Thread Tools | |
Display Modes | |
|
|