Our Dedicated Web server being hosted uses FM unlimited. In house we use FM Server. Is there a way to have the data entered into Fm unlimited auto updated into our in house FM server? ODBC or how?

The database we use for the web is a datafiled only and all interface screens with exact field names are used in house.

So its a matter of the 2 updating each other with new data.

quote:

---

Originally posted by vr5150:

Our Dedicated Web server being hosted uses FM unlimited. In house we use FM Server. Is there a way to have the data entered into Fm unlimited auto updated into our in house FM server? ODBC or how?

The database we use for the web is a datafiled only and all interface screens with exact field names are used in house.

So its a matter of the 2 updating each other with new data.

---

I doubt that you actually want to do this, as it make your valuable server data available to the world, but there are a couple of ways to accomplish this.

One is to simply use FMP Unlimited to actually host your server databases to the web. The web users would be interacting with your server databases directly.

The other way to still keep the databases seperate, but to come up with a pattern for updating. Perhaps every 2 hours you export data from the webDB, import into the serverDB, then export from the serverDB, clear the webDB and import the serverDB data. Or whatever pattern of updating matches what you need to do.

I fear that you do not really know what you intend to do here, but I am sure that you do not want to "mirror" the data.

------------------

=-=-=-=-=-=-=-=-=-=-=-=-=

Kurt Knippel

Consultant

Database Resources

mailto:[email protected]

http://www.database-resources.com

=-=-=-=-=-=-=-=-=-=-=-=-=