Backup database?

  • Thread starter Thread starter Stefan Milenkovic
  • Start date Start date
S

Stefan Milenkovic

I created application for comunicating with Hitachi902 device for blood
anylze. For each day database must be empty, and results from day before
have to be backed up in another database, for future analysis. Since I have
few relations, my question is there easy way to append all data from one
database to another without loosing relations? I mean, if I have key in one
table (for example name is KeyTest type AutoNumber with value 1), and child
table is in relation with master table over KeyTest. Now if there is already
data in master table of BackUp database, in my above example KeyTest will
became 4, for example, and in child (detail) table KeyTest must be also 4,
is there easy way for doing it?

TIA!
Stanko Milosev
www.milosev.co.yu
 
Dear Stefan:

I'm going to offer an opinion on this. The design you suggest
implementing seems a bad idea.

I recommend instead that you store all the data with the date it was
collected. When a user enters the application, find out the date for
which they want to see the data and show only that day's data. But
keep all the data in one database.

The work of moving all the data every day to another database is
generally unnecessary.

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts
 
Back
Top