odbc

[daverk]

I am just starting a project for a local private school. They currently have 5 different departments using 5 different dbs. Keeping all the different dbs up to date is driving them crazy. Most are on pc but 1 is a mac app, not in FM. They want a new db for the teachers to use to enter comments etc. Teachers use macs. My plan is to create a 'central' db to accomodate the teachers needs and also act as a clearing house for data. This would be in FM. The idea being that someone enters data in their db. The changed record gets picked up and changes made to the central db and then from there to the others. I know I should be able to read the data in the FM db through odbc using VB5 but can I also write changes to it that way?

Any comments on the viability of this plan would be appreciated. The network is NT4.0.

Thanks

Dave

ps. would love to put them all on one db but ain't gonna happen.

[amccallum]

Hi Dave

Yes you can do this... to write data to the FMP db you would need to set the other db up as the ODBC source then import ('pull') the data into FMP... to get data out of the FMP db you need to set the FMP db up as the ODBC source and either 'push' the data out or 'pull' the data into the other dbs.

A site that may be worth visiting is www.xsf.com

Ideally you should get all the data into one db system... but you think that won't happen... it is worth pushing pretty hard for it though.

Good luck.

quote:

---

Originally posted by daverk:

I am just starting a project for a local private school. They currently have 5 different departments using 5 different dbs. Keeping all the different dbs up to date is driving them crazy. Most are on pc but 1 is a mac app, not in FM. They want a new db for the teachers to use to enter comments etc. Teachers use macs. My plan is to create a 'central' db to accomodate the teachers needs and also act as a clearing house for data. This would be in FM. The idea being that someone enters data in their db. The changed record gets picked up and changes made to the central db and then from there to the others. I know I should be able to read the data in the FM db through odbc using VB5 but can I also write changes to it that way?

Any comments on the viability of this plan would be appreciated. The network is NT4.0.

Thanks

Dave

ps. would love to put them all on one db but ain't gonna happen.

---

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

Andrew McCallum

McCALLUM CONSULTING P/L

Sydney, Australia

61 2 9585 8775

61 407 482 609

[email protected]