copy a record to another database

  • Thread starter Thread starter AL R
  • Start date Start date
A

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
 
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?
 
AL said:
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
Click to expand...

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
 
Back
Top