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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top