Hello,
I have a situation where one my customer has a relatively large database that needs to be loaded at a remote site but I don't know what's the most efficient way to do it. The access database is around 100 megs so far and will increase. The remote site will be linked to the Internet through a satellite link. Now the application that loads the database will be installed on each workstation. The data is needed to generate 3d models. Now if everytime the application opens (for each user), 100 or more MB of data will need to travel over a slow satellite link (64Kb), it's going to take a long time. The database can and will be modified by both local users and remote users. What's the best way to keep both databases synchronized ?
Thanks
anthony
I have a situation where one my customer has a relatively large database that needs to be loaded at a remote site but I don't know what's the most efficient way to do it. The access database is around 100 megs so far and will increase. The remote site will be linked to the Internet through a satellite link. Now the application that loads the database will be installed on each workstation. The data is needed to generate 3d models. Now if everytime the application opens (for each user), 100 or more MB of data will need to travel over a slow satellite link (64Kb), it's going to take a long time. The database can and will be modified by both local users and remote users. What's the best way to keep both databases synchronized ?
Thanks
anthony