Dear All,

I have to create a database (preferablly in VBA and Access)for my client. But my client has users on three servers and these three servers dont talk to each others and dont let each other server users to get in.

They dont have common point where i can put the database and they all three can access that.

What is the best soln for this problem. My problem is willing to buy SQL Server 2000 if this is soln and HOW SQL Server will be helpful.

I think of two soln

1) Use replication in Access but i was told that if i moved replica and tried to email later , the data will be correpted.

2) The second soln is that I can put databases on three servers separately and then two servers will email xml file to third server and i will import data in third database

Last Question , How can I export/Import whole database in Access at once instead of exporting/importing individual object

Thanks

Neha