Automatically Created Local Copy of Linked Tables??

[pinballjim]

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!

[John Mishefske]

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
'-------------------------------

[pinballjim]

> 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!

[pinballjim]

> 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!

[John Mishefske]

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
'-------------------------------

[Jordan]

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.