I am working on an web application using access database. I need archiving of data. Can anyone help me find the best methodology to archive data with asp.net/c# using access databse?

Regards

There are a number of ways you can approach this, depending on what you mean by archiving.  You can set a flag (YesNo) to true to show that the record is archived, or you can copy it, and any related data to a separate table structure for archived records, or even to a separate database.  There is no "standard" way of doing this.

yes, i also got the idea of using separate table from internet.  And this is the best solution for future manupulation of archieved data than using yes/no flag.

Regards

When I have used Access in the past, I've simply set a Yes/No flag.  I've generally found that to be the simplest solution to implement and manage.

i go with mike and that thats the best way infact.

If u are maintaining large volumes of data its better to maintain a history table for the table so that the retrieval becomes a bit faster.