sn0rcha
Programmer
- May 15, 2002
- 2
- 0
- 0
Hey all,
I've got a question for all you access guru's I'm working on a problem at the moment as follows;
4 Different databases, all containing an identical table, 1 master database. Each day I need to sync the common database table from the 4 different databases into the one master database. Why not put them all into the same database you say? - Well unfortuneatly that is impossible as the databases are situated in different countries and there is no wan or vpn, only ftp access. Is there a way of syncronising the one table in the master database with the identical table that exists in the 4 seperate databases. I can write a php/cf script that would manually do the selects and inserts from all the seperate tables but I was wondering if there was a way to do it using an Access plugin or the likes?
Thanks in advance
I've got a question for all you access guru's I'm working on a problem at the moment as follows;
4 Different databases, all containing an identical table, 1 master database. Each day I need to sync the common database table from the 4 different databases into the one master database. Why not put them all into the same database you say? - Well unfortuneatly that is impossible as the databases are situated in different countries and there is no wan or vpn, only ftp access. Is there a way of syncronising the one table in the master database with the identical table that exists in the 4 seperate databases. I can write a php/cf script that would manually do the selects and inserts from all the seperate tables but I was wondering if there was a way to do it using an Access plugin or the likes?
Thanks in advance