Solved

Please explain strange fields in MS Access table

Posted on 2011-03-16
2
352 Views
Last Modified: 2012-06-27
I am involved with maintenance of an Access database that was designed years ago.
I find srange fields which I do not know in the database. Ido not know yet where and what fore they are used.
They are
s_Generation
s_Guid
s_Lineage.
Will someone with experience please have a look at the table definition and data to see if he can point me in a direction.
 Definition of table fields What the data looks like Definition of table fields What the data looks like What the data looks like
0
Comment
Question by:Fritz Paul
2 Comments
 
LVL 77

Accepted Solution

by:
peter57r earned 500 total points
ID: 35149808
These fields indicate that this is a replicated database.  The fields are used by the replication feature to control synchronisation between different database replicas.
0
 

Author Closing Comment

by:Fritz Paul
ID: 35150074
I will just have to go and study database replication.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question