Request some help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm sure most of you gurus can help

I am pretty good at figuring out the best way to design a relational database, but I'm sort of hitting a road block. My local firearm licensing officer wants me to design something in access for him to keep track of gun owners, etc. No problem.

But he wants this to be on his desktop and laptop and have them "sync" up, so the newest data is in both places. Problem is, I'm not 100% sure how to approach it, and it's not good if I accidently lose these types of records. I did some lurking and saw stuff about dirty records, and flagging them as "new" records, so I'd know which ones to copy. Would this be a way to do it, or is there a much better way? TI

Joe
 
If he is the only user, put the whole db on his laptop and teach him about
backups. In a multi-user scenario, you are talking about Access
Replication, which you need to read up on thoroughly before you attempt to
implement it.

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm

Joe said:
I'm sure most of you gurus can help.

I am pretty good at figuring out the best way to design a relational
Click to expand...
database, but I'm sort of hitting a road block. My local firearm licensing
officer wants me to design something in access for him to keep track of gun
owners, etc. No problem.
But he wants this to be on his desktop and laptop and have them "sync" up,
Click to expand...
so the newest data is in both places. Problem is, I'm not 100% sure how to
approach it, and it's not good if I accidently lose these types of records.
I did some lurking and saw stuff about dirty records, and flagging them as
"new" records, so I'd know which ones to copy. Would this be a way to do it,
or is there a much better way? TIA
 
Joe -
Kevin is absolutely correct, but another thing you may want to ask is
whether it is a good idea to have the data on a laptop at all. What
happens if he loses the laptop or it is stolen? If the data is at all
sensitive this could be bad in a legal sense. FYI, password protecting
an Access database is no good, there are a few websites (can't think of
them now) that will let you upload a password protected DB and will
email it back to you without the password protection.

Just some things to think about.
 
Back
Top