Copying table in Backend to another Backend

[Guest]

Hello All,

I have developed two applications one application creates a table that the
secods application needs to create a report. Is there a way to just copy a
whole table from one backend database into another backend database ?

Any suggestions would be greatly appreciated!

Thank you!

 

[Guest]

Hello.

Have you tried literally copying the table from the one database into the
other? i.e. selecting it in the database window, clicking Ctrl + C, and
pasting it into the database window in the other one. Haven't personally
tried this with tables, but I know it works with forms.

Cheers

David

 

[Guest]

David:

Thanks for the reply... I did find the answer with linking an external
table... (newbie to external linking)

Thanks!

 

[Guest]

You could create a command button on your switchboard or any form of your
database than when clicked it would import the table you need from the
database where it resides into your current database. Here's the code (or
you could make it a macro):

DoCmd.DeleteObject acTable, "marvel"
DoCmd.TransferDatabase acImport, "Microsoft Access",
"I:\IMPORT\IMPSAS\SHRFILES\DATABASE\GlobalTbls.mdb", acTable, "tblImpMarv",
"marvel"

In the sample above, I'm importing the table "tblImpMarv" from a LAN
location into my database as a new table named "marvel". Before I import it,
I make sure I have the most current table by deleting what I had previously
imported.