ansaurus

Question

Transfer table from one database to another?

Answer 1

+3 A:

You can use the TransferDatabase method of the DoCmd object to link relevant tables and then run suitable append and update queries to synchronize.

Remou 2010-05-21 13:58:10

Answer 2

+2 A:

You can access a table in DB X without actually transferring the table into DB Y.

SELECT *
FROM TableInDbX IN 'C:\SomeFolder\DB X';

HansUp 2010-05-21 14:00:13

But it is a lot easier building append and update queries with a linked table yesno?

Remou 2010-05-21 14:11:44

@Remou Yes, I would favor a link. But when I went back to include that suggestion, saw you already did.

HansUp 2010-05-21 14:30:23

This method is much easier but still the query well not pass unless the full path is there unless Access uses App.Path then everything well be solved reason cause this program well be tested on my computer and non of them have the same user or directories

Mahmoud 2010-05-21 14:30:50

@Mahmoud Then perhaps you should link the table as Remou suggested, and manage the links on the users' systems with something like the J Street Access Relinker from http://www.jstreettech.com/cartgenie/pg_developerDownloads.asp

HansUp 2010-05-21 14:43:42

ansaurus

tags:

views:

answers:

Transfer table from one database to another?

related questions