I would like to copy a table linked to another database and make a local
copy. In my tests, a local copy then local query is faster than a linked
query that uses most of the records. Any Help would be appreciated

On Wed, 5 Nov 2008 10:50:01 -0800, Brad Hall wrote:

> I would like to copy a table linked to another database and make a local
> copy. In my tests, a local copy then local query is faster than a linked
> query that uses most of the records. Any Help would be appreciated

On your Main Database folder, delete the table. NOTE: You are NOT
really deleting the table, just the link to it.
Then click on File + Get External Data + Import.
Navigate to the other database, and select the table. Click on Options
and select Definition and Data.
Click OK.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Sorry, I didn't make myself clear. I would like to do this programmatically.

"fredg" wrote:

> On Wed, 5 Nov 2008 10:50:01 -0800, Brad Hall wrote:
>
> > I would like to copy a table linked to another database and make a local
> > copy. In my tests, a local copy then local query is faster than a linked
> > query that uses most of the records. Any Help would be appreciated
>
> On your Main Database folder, delete the table. NOTE: You are NOT
> really deleting the table, just the link to it.
> Then click on File + Get External Data + Import.
> Navigate to the other database, and select the table. Click on Options
> and select Definition and Data.
> Click OK.
> --
> Fred
> Please respond only to this newsgroup.
> I do not reply to personal e-mail
>

1. Delete the link - something like this (or just leave it there and use a
different name in step #2 below):

Dim db As DAO.Database
Set db = CurrentDb
db.TableDefs.Delete "MyLinkedTable"

2. Import the table - something like this:

DoCmd.TransferDatabase acImport, "Microsoft Access", _
"C:\MyOtherDB.mdb", acTable, "MyTableThere", _
"MyTableHere"

"Brad Hall" wrote:

> Sorry, I didn't make myself clear. I would like to do this programmatically.
>
> "fredg" wrote:
>
> > On Wed, 5 Nov 2008 10:50:01 -0800, Brad Hall wrote:
> >
> > > I would like to copy a table linked to another database and make a local
> > > copy. In my tests, a local copy then local query is faster than a linked
> > > query that uses most of the records. Any Help would be appreciated
> >
> > On your Main Database folder, delete the table. NOTE: You are NOT
> > really deleting the table, just the link to it.
> > Then click on File + Get External Data + Import.
> > Navigate to the other database, and select the table. Click on Options
> > and select Definition and Data.
> > Click OK.
> > --
> > Fred
> > Please respond only to this newsgroup.
> > I do not reply to personal e-mail
> >