Transfer data from one Access DB to another

[Gloria]

The structure of the Access application consists of a FrontEnd Access file
that contains forms, queries, and link access to tables that are in a BackEnd
Access file.
I created a form in the FrontEnd file that allows the user to open an
independent Access DB. The DBs have the exact same table structure. The
user selects the data to append to several BackEnd database tables.

I am trying to use the function DoCmd.TransferDatabase.
Is this the right way to go?

Thanks,
Gloria

 

[NetworkTrade]

not sure. not sure what you are trying to accomplish...

do you want a FE to put/retrieve data from multiple dbs ? or are you trying
to sync the multiple dbs to have identical data?...or do you want the FE to
'toggle' from one db to the other for some reason....??

 

[Gloria]

The FE has a transfer form. The user can select another Access DB from
anywhere, i.e. Server or desktop. Lot names are displayed on the form and
the user can select which lots to transfer to the BackEnd database that is
linked to the FE. All transfers go from a user selected database to the
BackEnd database.
The data transfer involves 4 tables.
The Lot Table only has one entry so I am using an insert action-query with
the function, DoCmd.RunSQL, to transfer. This works fine.
The Summary Table also has one entry but I need the GlobalKey from the Lot
table in the BackEnd DB. I query the table for the last entry but I am
having trouble using DoCmd.RunSQL for this insertion.
When I put the GlobalKey in the SELECT statement of the INSERT INTO
action-query, it reads it as an input parameter.

Is there any way to use the DoCmd.RunSQL without seeing the input parameter
box?
Is there a better way of doing this?

Thanks,
Gloria

 

[Gloria]

To clarify the big picture, the databases may have different data in each. I
don't want to completely overwrite the data in the BackEnd database with the
database the user selects. I want to append the lots selected from one DB to
be transfered to the BackEnd database.
Hope this helps.
Gloria