Copy linked tables

I

Igor G.

How to automatically copy linked tables every 8 hours to another network
location, if possible with changed name or in zip?
Example:
 
S

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?
 
I

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top