Export records to another Access Data Base

  • Thread starter Thread starter Suze
  • Start date Start date
S

Suze

I am using Access 2000 and am just not sure if what I
want to do is possible.

My data base holds patient names and details of
appointments in two seperate but relational tables. Once
an apppointment is given and the treatment finished, the
patient is discharged and this is recorded in the
appointment details. Is it possible to send these records
to another data base for storage using a macro but
leaving the patient details in place? I was thinking of
an IsNotNull condition after losing focus? Thanks
 
Suze said:
I am using Access 2000 and am just not sure if what I
want to do is possible.

My data base holds patient names and details of
appointments in two seperate but relational tables. Once
an apppointment is given and the treatment finished, the
patient is discharged and this is recorded in the
appointment details. Is it possible to send these records
to another data base for storage using a macro but
leaving the patient details in place? I was thinking of
an IsNotNull condition after losing focus? Thanks
Click to expand...

Even if you never see the patient again there is little reason to do this
until your database hits it's 2Gb limit.

If you see over 100 patients a day five days a week for more than five years
it is unlikely you will reach the limit.
You can move the records by doing an append query, then deleting them based
on some criteria (add a Closed "yes/no" field) but if you need to get them
back you will need to reestablish the relationship and that may be a
problem.
 
Back
Top