Updating main database from record subset

  • Thread starter Thread starter Andrea
  • Start date Start date
A

Andrea

How do I break one main database into 2 separate databases
each accessing their own subset of data but updating to
the main database at night?
Problem is one subset will be both editing records and
adding new records. Or would it be just as simple to
rewrite existing queries to limit on criteria.
 
How do I break one main database into 2 separate databases
each accessing their own subset of data but updating to
the main database at night?

You can use db replication but...
Problem is one subset will be both editing records and
adding new records. Or would it be just as simple to
rewrite existing queries to limit on criteria.

If both locations can see the data database, then there is really no reason
to split the file up physically. Simply providing the suitable flags, and
queries in each front end that look for the appropriate records should be
satisfactory in most cases. If you have a severe need for inpenetrable
division between them, then you can use Access security to restrict and
control access to everything.

The advantage of keeping the single database is the use of common data
(codes, lookups, addresses, etc) and decision support that may need info
from both sides at once. The latter can be done over two files, but it's a
fiddle and quite easily avoidable.

HTH


Tim F
 
Tim

Thanks for your help on this.

Andrea
-----Original Message-----


You can use db replication but...


If both locations can see the data database, then there is really no reason
to split the file up physically. Simply providing the suitable flags, and
queries in each front end that look for the appropriate records should be
satisfactory in most cases. If you have a severe need for inpenetrable
division between them, then you can use Access security to restrict and
control access to everything.

The advantage of keeping the single database is the use of common data
(codes, lookups, addresses, etc) and decision support that may need info
from both sides at once. The latter can be done over two files, but it's a
fiddle and quite easily avoidable.

HTH


Tim F



.
 
Back
Top