Your question is a little vague. I am not sure what you mean by "publish" and why you chose that word rather than access, unless you mean that you want all sites to be able to add data to the database.

I assume that the sites will access via an application written in something like FoxPro or Visual Basic, and that you will not simply allow sites to manipulate the raw data through whatever database software (VFP, Access, FileMakerPro, SQLServer, SAS) they happen to have.

That said, you need to assure that your applications are programmed to allow for multi user read/write access, otherwise the first time two sites try to access the same tables thing could go bad.

Are all the sites on the same network? If so, the database can be accessed by all the sites, it is a matter of giving each site the interface. I don't do this since that requires multiple installations of the application, and re-installing when the application changes.

IF they are not all on the same network then you might consider providing access through a terminal server. This is a quick approach if you already have a stand-alone "monolithic" application that you want to make accessible to many users. If all the sites have internet access then you can install the application and the data at the server and let them access via the terminal server. Then you have only one installed application which makes maintenance a bunch easier.

A third approach is to move to a client/server application where the data is located on the server and the client machine has an installed interface to the application. For apps like this I use Web Connect and have an internet browser as the client application. This is nice because it requires no installation on the client machine.

Good luck!

>I have a system that I need to publish among different locations within our company. How can I have each site access the same database? It's a vfp database.
>
>Thanks