Re: Create local copy of Linked Table
- From: "John Nurick" <j.mapson.nurick@xxxxxxxxxxxxxx>
- Date: Tue, 20 Jun 2006 16:20:35 +0100
Instead of trying to copy tables, use queries to handle the data. For each
table, you need a delete query to delete the "old" data from the table in
the other database, and an append query to copy the current data.
"stickandrock" <stickandrock@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:D71CB59F-6485-4A55-BC91-7DD94F725CD9@xxxxxxxxxxxxxxxx
I have a database with 20 linked tables. I want to take an image of those
tables once a day and create a copy of tables within another database for
endusers to access. If I do a transferobject macro the resulting table
remains a linked table, not as a stand alone copy.
Thank you in advance for any all input.
.
- Prev by Date: Re: Linked table shows no data
- Next by Date: Re: Exporting mass MS Word and Excell OLE's to seperate MS Word and Excell files from Access 97 DB
- Previous by thread: Re: Linked table shows no data
- Next by thread: Exporting Data
- Index(es):
Relevant Pages
|
Loading
