Database archiving?

  • Thread starter Thread starter Stanko Milosev
  • Start date Start date
S

Stanko Milosev

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
 
Stanko,

Don't use an autonumber field in the backup database. If you use a Long,
Access will transfer across the original value.

HTH

--
Rebecca Riordan, MVP

Seeing Data: Designing User Interfaces
Designing Relational Database Systems, 2nd Edition
www.awprofessional.com

Microsoft SQL Server 2000 Programming Step by Step
Microsoft ADO.NET Step by Step
www.microsoft.com/mspress
 
Back
Top