Solved

Please explain strange fields in MS Access table

Posted on 2011-03-16
2
328 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

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

APEX (Application Express) is used to develop a web application from Oracle. SQL Workshop is one of the tools that comes with Oracle APEX to query or modify the database objects or to make any changes to the structure.
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!
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…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

747 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now