By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,647 Members | 1,618 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,647 IT Pros & Developers. It's quick & easy.

Automatically Created Local Copy of Linked Tables??

P: n/a
Hello everyone,

I'm looking for a simple way to create a local copy of a linked table.

I've got a database that links about 10 tables from other databases.
This works fine on my machine, but I need to distribute one single
database to others and cannot have any linked tables.

The only way I've figured out is to run the linked tables through Make
Table queries to make a temporary table, delete the linked table, and
then rename the temporary table to the name previously used by the
linked.

So I go from table A-linked to table A-temp, delete A-linked, and
rename A-temp to A-linked.

This seems needlessly complex to me, other database software I have
used has very simple commands to accomplish this...

Any help is much appreciated!
Nov 12 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
pinballjim wrote:
Hello everyone,

I'm looking for a simple way to create a local copy of a linked table.

I've got a database that links about 10 tables from other databases.
This works fine on my machine, but I need to distribute one single
database to others and cannot have any linked tables.

The only way I've figured out is to run the linked tables through Make
Table queries to make a temporary table, delete the linked table, and
then rename the temporary table to the name previously used by the
linked.

So I go from table A-linked to table A-temp, delete A-linked, and
rename A-temp to A-linked.

This seems needlessly complex to me, other database software I have
used has very simple commands to accomplish this...

Any help is much appreciated!


Delete the linked tables and import them.

File, Get External Data, Import.

--
'-------------------------------
' John Mishefske
'-------------------------------

Nov 12 '05 #2

P: n/a
> Delete the linked tables and import them.

File, Get External Data, Import.


Is there not an automatic way or a command to do this? I'm trying to
avoid having to manually import the documents.

Thanks!
Nov 12 '05 #3

P: n/a
> Delete the linked tables and import them.

File, Get External Data, Import.


Is there not an automatic way or a command to do this? I'm trying to
avoid having to manually import the documents.

Thanks!
Nov 12 '05 #4

P: n/a
pinballjim wrote:
Delete the linked tables and import them.

File, Get External Data, Import.

Is there not an automatic way or a command to do this? I'm trying to
avoid having to manually import the documents.


Sure. Use:

DoCmd.TransferDatabase acImport, , "c:\temp\tester.mdb", _
acTable, "Employees", "Employees"

Check the online help for TransferDatabase() to get the syntax
explanation.

--
'-------------------------------
' John Mishefske
'-------------------------------

Nov 12 '05 #5

P: n/a
Save the linked tables with Name+"Linked"
And create a CreateTableQuerry to import the data to Name table.
Then create a macro that calls all the Querry needed to import the data, and
call this macro with an Update button or in an Autoexec macro (this will
allow you to update the data when you are connected or when you starts the
application.
Nov 12 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.