Row Level Tracking

  • Thread starter Thread starter Mike B
  • Start date Start date
M

Mike B

I use access 2000. After reading the help subject on this matter I am
confused as to whether or not to check the "Row Level Tracking" in the table
properties.
The default is checked on my tables that are linked to the back end. I have
five front ends connected to the back-end three off which do the same
function (data input) the other two are set up to run reports and queries
and offer different access then the first three. Any of the three may access
the same record at any given time.
Can somebody explain the best scenarios to use or not use record level
tracking? "Layman" terms are best.
 
Level record tracking is only when you are using replica's. Replicas refer
to what is called copies of the ACTUAL database (which you don't have).
Replication is a process where two databases talk to each other and exchange
data. Since you are not using replication, then the box does not apply, and
will make no difference. However, since you are not using replication, then
I would of course leave the box un-checked.

You can read up on replication at:

http://www.microsoft.com/accessdev/articles/bapp97/chapters/ba20_1.htm
 
Back
Top