Options for synchronizing an Access Database
Posted on 2007-08-05
I am planning to develop an Access 2000 Database to store patient data for my small medical practice. Three or four people might be users of the database. One, maybe two, will be laptop users working outside the office at hospitals or other patient care sites. At the office I have Small Business Server 2000 and 4 Windows XP client desktops.
A partial view of the table relationships would be:
ContactID <<--------------- ContactID (GUID)
Problem PatientID <<----------------PatientID
Exam Date PatientName
Assessment Time Date of Birth
etc UserID Etc.
So, let's say I have the backend of the database on the server sitting at "x."
I go to the hosptial and enter contact "x+1", so does my medical assistant back at the office.
So, now there are two "x+1" contacts.
I know that this might be an example where replication might be used or some might recommend a Terminal Server approach. Alternatively should I generate some GUID based on code which I have seen on this site which takes the date/time date of the record creation and randomizes it somehow.
With the Terminal Server approach, I believe I would have to buy new hardware and software. Plus I need to make sure the server connection is HIPAA compliant.
I would appreciate some advice.