Software and Programs Thread, Access: Exporting a Record to another database. in Software & Hardware , Games; Office XP: To bring down the size of our database we have made a copy of the databsed (Called Archive) ...

Short Link: http://forum.egypt.com/enforum/showthread.php?t=20185

newbe · 22-01-2009, 08:30 PM

Office XP: To bring down the size of our database we have made a copy of the databsed (Called Archive) then in the live database we have deleted the older records. Even though we have only deleted records that are "Closed" before the end of...

Office XP:

To bring down the size of our database we have made a copy of the databsed (Called Archive) then in the live database we have deleted the older records.
Even though we have only deleted records that are "Closed" before the end of 2007, occasionally one of these will become Live again.

I know that I could open the the table in both the archive and the live database and copy and paste the record over but I would not like to show my colleagues this method (we would end up without a database

).

Ideally, I would like them to be able to bring up the record using the normal form in the archive database, click a button and it would export the current record over to the live database.

As the archive is just a copy of the live database before we deleted the records there would be no problem with field names etc.

Any advise.

Thanks
SBF

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Software and Programs Thread, Access: Exporting a Record to another database. in Software & Hardware , Games; Office XP: To bring down the size of our database we have made a copy of the databsed (Called Archive) ... Short Link: http://forum.egypt.com/enforum/showthread.php?t=20185