We use a webhost that provides us with a SQL 2000 DB. They are a pretty good host in that they allow remote connections to the DB (many hosts do not)

This means that in addition to being able to use Microsoft's Enterprise Manager utility for managing tables and such, I can also make remote connections to the DB from my own windows applications.

So we have this big customer database sitting out there on our webserver, and we access it from here in a windows app I made. Our customers also access it via an ASP.NET app on the webserver.

My question is this:

Is there a way we can possibly use a local sql server here for faster access, but have the server here also sync up real time with the one on the webserver, so that customers accessing it will also see the same data?

Problem is that at times it can be a bit slow to access the data over the web for us when reading lots of records, where as its about 10x faster using a local DB on the network here.