|
security
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Copy linked tablesHow 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! Try Programs | Accessories | System Tools | Scheduled Tasks to copy the
database containing the table to which the linked table points. -- Show quoteHide quote*************************** 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! 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! |
|||||||||||||||||||||||