Solved

Please explain strange fields in MS Access table

Posted on 2011-03-16
2
372 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

Question has a verified solution.

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

Recently, Microsoft released a best-practice guide for securing Active Directory. It's a whopping 300+ pages long. Those of us tasked with securing our company’s databases and systems would, ideally, have time to devote to learning the ins and outs…
In this series, we will discuss common questions received as a database Solutions Engineer at Percona. In this role, we speak with a wide array of MySQL and MongoDB users responsible for both extremely large and complex environments to smaller singl…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

627 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