Hi,
Could anyone tell me how to well manage an access database running on a vb 6.0 application such that after a given number of records a backup is made automatically to the archive and all records in the current table are deleted to give room for quicker data access and retrieval. Mark you it should be such that whenever you want to access records whether they are on the current table or the archive you should just do it normally as if the records are in two different locations. I am using ADO's to connect to the database.