At our office we have several internal CRM and accounting types of programs that are - *gasp* - running on an old DOS-based version of FoxPro. So everything works perfectly and is lightning fast, etc. so management has no desire to replace this custom app.
However, we would love to use ColdFusion as a bridge to add functionality to these applications. I've already been able to do some icredible things on a local dev machine with local copies of all of the data. On that machine I used MS Access to "link" to the various dbf files so that I could access these tables using joins in cfqueries.
There are dozens and dozens of dbf files in this app and the only way I know to add them is using the "link table" feature of Access? I there a better way to do this? I know tha it is not wise to use Access in an enterprise situation (of course, someone will prbably say it's unwise to use a DOS-based version of a custom FoxPro app in 2010!)
And as a follow-up to this question: assuming the use of the MS Access method described above or (hopefully) a more robust method suggested here, are there any best practices and/or things that I need to be concerned with so as not to "interfere" with the old DOS-based app while "touching" these same tables?
Thanks for any and all suggestions!
Andy
1
Reply
AdChoices