Export records to another Access Data Base

[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

 

[Mike Painter]

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

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.