We need an archive solution for MsAccess tables on the following way:
There is a MsAccessXP mdb file (Access2000 or 2002 compatible) which contains about 14 tables. The tables are not complex but some of them has a relationship to the others. We need an other mdb file for historical data backup and a function which moves records from the main mdb to the backup one based on user given criterias. The function should do data integrity tests before doing the data move and sending proper messages about problems. The records which doesn't have problems and suits the given criterias should be moved to the archive and be deleted from the main application. The archive mdb should have the same structure as the main one, however they need changes like eg. AutoNumber fields to long fields without auto numbering.
This project doesn't involve UI or just the minimum which is necessary to do tests or to show feedback information. Feedback information should be stored into a new DB table.
The deadline is a key factor. Please bid if you can do it without any delay after project reward.
Hello
Me an Ms-Access Expert working on MS-Access & VBA for the past 12 years. I am ready to do your work and could start right now. I have already done a no. of successful Access Projects and can provide u sample copies if you so desire. U can expect quality work in time.
Thanks