Copy .mdb file from web host to local mac server at timed intervals

Posted on 2006-05-15
Medium Priority
Last Modified: 2013-11-30
Hi Experts

Is it possible to copy an access database from our web host to our local mac server at timed intervals. If so, how would we go about this. If it was some sort of 'coded' thing could you please proved an example.

Question by:hnEE
1 Comment

Accepted Solution

nexissteve earned 1500 total points
ID: 16681451

I am assuming the host is a 2k or 2k3 machine.

FTP would probably be the easiest way to transfer on a timed basis. If FTP server in not installed on your mac then install it. Create a batch file on your host with the following. Create a scheduled task on the host to run the batch file.

cd \
cd accessDBfolder
Ftp -s:ftp.txt

Create a txt file called ftp.txt

mput accessmdb.mdb


Obviously you will need to replace the ipaddress , username, password and filename to suit your circumstance.
You will also have to change the batch file so the path is correct to your working folder.

Hope this helps.




Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you’re involved with your company’s wide area network (WAN), you’ve probably heard about SD-WANs. They’re the “boy wonder” of networking, ostensibly allowing companies to replace expensive MPLS lines with low-cost Internet access. But, are they …
This article outlines the struggles that Macs encounter in Windows-dominated workplace environments – and what Mac users can do to improve their network connectivity and remain productive.
After creating this article (http://www.experts-exchange.com/articles/23699/Setup-Mikrotik-routers-with-OSPF.html), I decided to make a video (no audio) to show you how to configure the routers and run some trace routes and pings between the 7 sites…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question