copy a record to another database

[AL R]

Can anyone plese tell me if there is a way to copy a
single record or multiple records from a form into a
duplicate database. Except that the duplicate database
will be empty of records. The form is based on a query
that is based on a table.
Thanks

 

[Sal Rosario]

You can use VBA code to establish an ADO connection to the duplicate
database.

 

[AL R]

I guess that I'm in the wrong newsgroup because I don't
know what you mean by VBA or ADO. I created this database
by doing research and trial and error, so i'm not a pro
at this. Is it possible for you to tell me a little more?

 

[Bas Cost Budde]

Can anyone plese tell me if there is a way to copy a
single record or multiple records from a form into a
duplicate database. Except that the duplicate database
will be empty of records. The form is based on a query
that is based on a table.
Thanks

What is the higher goal here? You are using the terms 'table' and
'database', I gather you know the difference? Is the second database for
backup purposes, maybe?

My idea is like this:

* in the database, link a table from the other database
* create an INSERT INTO query (if you haven't yet) that copies your
records from the local table into the linked
* run the query (if you haven't yet)
* remove the link