Hi,

We have a accounting/inventory program that uses MS SQL as the database, with VB and Access for reporting. We want to make the database available online. ie.. Our clients can search the inventory and make orders from it. We do not want to install a local web server inhouse. What is our best option for creating this.. should we stick to a MS SQL database /ASP online or export our data and then re-import it to a mySQL/PHP database online. The database online should be able to sync with the local database on a daily basis as well.

thanks in advance for any insight you can offer,
Jacob

Hi

How is the client to view the data if you don't have a web server to display it! You can setup a server anywhere and then just allow remote connections with limited access to your current in house database. What's the point of mirroring a database that already exists? Unless your doing some sort of version control a mirror is a waste of time to implement and maintain!

demo