Home All Groups Group Topic Archive Search About
Author
25 Sep 2006 4:21 PM
Igor G.
How to automatically copy linked tables every 8 hours to another network
location, if possible with changed name or in zip?
Example:
-----------
\\server\tables.mdb     to     \\server2\tables2.mdb
Thanks!

Author
26 Sep 2006 6:02 PM
S Panja
Try Programs | Accessories | System Tools | Scheduled Tasks to copy the
database containing the table to which the linked table points.
--
***************************
If the message was helpful to you, click Yes next to Was this post helpful
to you?
If the post answers your question, click Yes next to Did this post answer
the question?


Show quoteHide quote
"Igor G." wrote:

> How to automatically copy linked tables every 8 hours to another network
> location, if possible with changed name or in zip?
> Example:
> -----------
> \\server\tables.mdb     to     \\server2\tables2.mdb
> Thanks!
Author
27 Sep 2006 1:24 PM
Igor G.
Thanks Panja,
I solve this problem on this way:

Dim SourceFile, DestinationFile, Update
Update = " (" & Str(Date) & ")"
SourceFile = "D:\Products_tables.mdb"
DestinationFile = "D:\Copyed tables" DestinationFile = DestinationFile &
Update & ".mdb"
FileCopy SourceFile, DestinationFile


„S Panja“ wrote:

Show quoteHide quote
> Try Programs | Accessories | System Tools | Scheduled Tasks to copy the
> database containing the table to which the linked table points.
> --
> ***************************
> If the message was helpful to you, click Yes next to Was this post helpful
> to you?
> If the post answers your question, click Yes next to Did this post answer
> the question?
>
>
> "Igor G." wrote:
>
> > How to automatically copy linked tables every 8 hours to another network
> > location, if possible with changed name or in zip?
> > Example:
> > -----------
> > \\server\tables.mdb     to     \\server2\tables2.mdb
> > Thanks!