Moving Records to Seperate Tables in a Different .mdb File

[CassandraB]

I was wondering if anyone knows how I can do this.

What I would like to do is .... after selecting a record in my form (sign inventory) and subform (sign history), I would like to take the sign and its history I've selected and click a button/control and move the records to another table(s) in a seperate .mdb file.

For example for archived signs, if the sign is archived, the sign and it's history do not need to be in the tables any longer but I want to keep an archive date file by year of the archived data (ArchivedSignInventory2003 & ArchivedSignHistory2003 tables).

Would it be possible to have a button (on the form) to take the records I've selected from the form and place them in the two archived tables in a seperate .mdb file?

I would appreciate anybody's expertise. Thanks!

 

[dcx693]

You can open the table in the other mdb file as a recordset and insert your data there. Here is a link to the post with code: After Splitting DB error - Object isn't supported.

 

[CassandraB]

I don't think this is what I want to do ....................

 

[dcx693]

No, the link does not do exactly what you want, but it contains code to open up a table in another database. I expected that to be the hard part. The moving of records wouldn't be all that different than for a table within the same database.

 

[neileg]

Can't you just link those tables into your current database and use an append query to update them?

 

[dcx693]

As neileg suggested, why not do that?