Thank you Dorian,

I got the impression that Replication was for use on a server or used like
Briefcase between two computers. Perhaps I was in error and I will read up
on Replication as you suggest.

As for the use of SSN, I was only giving SSN as an example of a complex
numbering system to be used as an ID. Since 99% of the individuals in the
historical db are dead and most died long before Social Security was
invented, you comment made me smile.

Again, thanks for your prompt reply. R-



"mscertified" wrote:

Look up REPLICATION in Access help. I strongly advise against storing SSN in
a database, especially an Access database. Also since you will be storing
other personal information about people, I would make sure your database is
as secure as it can be.

-Dorian