How Refresh Linked Tables On Startup?

I have an Access database that has three pretty big linked tables via ODBC. Is there a way to "copy" these tables over to the local database on startup so the querys/reports will respond much quicker?

here is my initial thought...
Since you have a table linked allready, you could copy that table. The easiest way I can think of is to import the same table. You can do this through a macro, or the same way you link the tables...my suggestion is you create 2 querys one to delete all records from the "imported" table and on to append all data from the linked table to the imported...about runnint it automatically...you can create a form that on open runs the a macro containg the two queries you made, and then closes...if you dont want to be prompted at all go to TOOLS->OPTIONS->EDIT/FIND
and uncheck action queries. That should do it.

create a macro that executes the make-table query

then...create a form

on the form on_load Function add this code...

Dim stDocName As String
stDocName = "YOURMACRONAME"
DoCmd.RunMacro stDocName
DoCmd.Close

you can make this form any size you want...now, TOOLS->STARTUP set the display form/page to the form you just created. This form will execute the macro and then close the form.

Actually, after having worked on this all night... I think what I really want to do is find a way to automatically run a query when the application starts up. Do you know how I can accomplish this? Its a make-table query which works fine. Now I just need to automate it.

--Steve