link a table from a separate database to another separate database

[legos]

Hi everyone,
I am trying to link a table in a seperate database project to another project. Here is where i'm stuck
DoCmd.TransferDatabase acLink, "Microsoft Access", countyDB, acTable, api, api

countyDB is the location of the database that I want to link the table to.
api is the name of the table that i want to link and I want the table to be named api in countyDB also.

For a graphical reference
CurrntPrj Prj1 Prj2
inventory api<-api

The code i'm working on already creates Prj1, Prj2, and the api table in Prj1. It then takes the items needed from the inventory at of the currentPrj and adds them to the api table in Prj1. After this I want the api table linked to Prj2 so that it can be viewed and edited in both Prj1 and Prj2.

Durible Outer Casing to Prevent Fall-Apart

 

[PHV]

Your code actually try to create in the CurrentDb a table linked to a table from countyDB.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[randy700]

How about...

DoCmd.TransferDatabase acLink, "Microsoft Access", [COLOR=red]"OutsideDatabaseName"[/color], acTable, api, api

Randy