By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,679 Members | 2,331 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,679 IT Pros & Developers. It's quick & easy.

Archiving various versions of data

P: 72
Hi Everyone,

I have a database that currently has two types of tables: one type has all of the current data, and the other type has all of the previous, outdated data. I already have command buttons on my form that opens a previous data query, so that the user can view the outdated data if he/she needs to.

However, the database may need to grow to allow a way for users to view various versions of the data. People at my work agree that some type of archiving system needs to be implemented.

Does anyone have suggestions for the best layout for an archived database?

Thanks!
Jun 20 '07 #1
Share this Question
Share on Google+
4 Replies


tdw
100+
P: 206
tdw
Hi Everyone,

I have a database that currently has two types of tables: one type has all of the current data, and the other type has all of the previous, outdated data. I already have command buttons on my form that opens a previous data query, so that the user can view the outdated data if he/she needs to.

However, the database may need to grow to allow a way for users to view various versions of the data. People at my work agree that some type of archiving system needs to be implemented.

Does anyone have suggestions for the best layout for an archived database?

Thanks!
Do you mean that data referring to a particular thing (product, work order, or whatever) will change over time, but that all previous incarnations have to be kept and accessible as well?

Or do you mean that you want old outdated things that no longer exist to be archived?
Jun 21 '07 #2

puppydogbuddy
Expert 100+
P: 1,923
Do you mean that data referring to a particular thing (product, work order, or whatever) will change over time, but that all previous incarnations have to be kept and accessible as well?

Or do you mean that you want old outdated things that no longer exist to be archived?

The following links contain guidelines for creating and naming the archive tables, appending data to it, and deleting data from the current version.

As an alternative way of archiving, you might consider creating "read only" copies of your existing mdb file, rather than archiving on a transaction basis as described in the links

Archiving records in an Access database
http://office.microsoft.com/en-us/ac...345681033.aspx


Example using an append query for archiving records
http://www.databasedev.co.uk/append_query.html
.
Jun 22 '07 #3

P: 72
The following links contain guidelines for creating and naming the archive tables, appending data to it, and deleting data from the current version.

As an alternative way of archiving, you might consider creating "read only" copies of your existing mdb file, rather than archiving on a transaction basis as described in the links

Archiving records in an Access database
http://office.microsoft.com/en-us/ac...345681033.aspx


Example using an append query for archiving records
http://www.databasedev.co.uk/append_query.html
.

Thanks! I will test out these ideas.
Jun 22 '07 #4

P: 72
Do you mean that data referring to a particular thing (product, work order, or whatever) will change over time, but that all previous incarnations have to be kept and accessible as well?

Or do you mean that you want old outdated things that no longer exist to be archived?
In this case, both situations apply. But I think the first question is the best way to view our situation.
Jun 22 '07 #5

Post your reply

Sign in to post your reply or Sign up for a free account.