Moving from one database to another?

  • Thread starter Thread starter clara
  • Start date Start date
C

clara

Can somebody tell me if this is even possible? I have a
database of insurance claims that are either pending,
approved or rejected. Now, they are asking me if, when
the selection of approved or rejected is made, can that
record be kicked into a separate database so that we will
have three databases instead of one? Ultimately, they
only want the main database to contain just the pending
records. I am very new at Access-can something like this
be done?
 
Yes, it can be done with linked tables and/or the
TransferDatabase action (in code or a macro) however,
depending on your long-term database needs, it's often
better (and always easier) to just keep seperate tables
within the same database.

Unless database size is an issue, I'd build three tables
(tblPending, tblApproved and tblRejected) and, as pending
claims were approved or rejected, I'd move them to the
appropriate table (this would be done with an AppendQuery
followed by a DeleteQuery).

If it is an issue or they're insistant on multiple
databases, create the other databases and link to the
appropriate tables (File > GetExternalData > Link) and
have your data append to them. You should be able to use
an AppendQuery on a linked table.

Me, I always vote for fewer databases wherever possible.

Hope this helps!

Howard Brody
 
Thanks to both of you for responding. I will do some
research on this to see which is the best way to go.
 
Back
Top