Transfer Data from Access to Access

  • Thread starter Thread starter SSteger
  • Start date Start date
S

SSteger

Is there a way to build a ASP page that would transfer the data from one
Access DB to another Access DB on a remote server. Both DBs are exactly the
same structure. I have a backup server and I want to make sure that the
information is always up to date.

S Steger
 
Since there may be a lot of data, the best way may be to build a batch file
which runs at prescheduled times and ftp's the file from one server to
another.
A typical ftp script might look something like:

open www.mydomain.com
UserName
Password
bin
cd C:\MyFolder
put "database.mdb"
quit
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
You must log in or register to reply here.

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

Similar Threads

Integrating Data from multiple Access databases 1
How to export table from outlook into ms access table? 0
Connect to Remote Access Server 5
ACCESS PErmissions Issues 6
Is it possible with Access VB to check if any users are logged ontoanother Access DB? 2
export from access to mySQL? 2
Access and Terminal Server - very high CPU usage 0
Managing Across Multiple Application Copies 4

Back
Top