cut and paste a table?!?!

[kwokv616]

I want access to automatically cut and paste (or copy and paste then delete) a table into a new database when i click on a button.



how do i do it?

thanks!

[gpl]

I want access to automatically cut and paste (or copy and paste then delete) a table into a new database when i click on a button.



how do i do it?

thanks!

I think that rather than copy/paste, you need to link the new database, then you can Insert Into the new database, when that is done, drop the old table

Graham