database replication

  • Thread starter Thread starter _______TIM_______
  • Start date Start date
T

_______TIM_______

Hi,

I have a novice question about Access database
replication. If I have a database that is set up with
data, relationships and queries that I like and want to
duplicate with new data every day, what is the best way to
set up a template or replica so that I just have to import
the new data to the tables? I used the replication
feature to duplicate a database. Then I deleted the data
in the tables and imported new data. The problem with
this method is not being able to save the tables or data I
am deleting. Do I replicate a replicated database? I
hope someone can tell me how to start with queries I have;
with blank tables appropriately named and are able to save
the new database uniquely every day without having to
delete the old data. Thank you in advance for your help.

Regards, Tim
 
first of all, sounds like you want a copy of your original
database, not a replicate (they're two different things).
to copy your db, just open Windows Explorer, find the file
and Copy, Paste.

second, if you want to work with new data every day but
not lose data from previous days, suggest you use just one
database instead of a new copy every day. just add a
Date/Time field to each table that receives new data. set
the default value of the field to Date(). then each day
when you import new data, it is date-stamped. simply
modify your queries to pull data for a specific date, and
you're set - current and "old" data are all available at
your fingertips.

hth
 
Back
Top