Copy linked tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How to automatically copy linked tables every 8 hours to another network
location, if possible with changed name or in zip?
Example:
 
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?
 
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
 
Back
Top