>Administrative Information Services puts the data from the
>main database into a Microsoft SQL server database. We then
>connect via ODBC through Access to the SQL server. We
>maintain the Access database locally to increase response
>time.
>Dave Benham wrote the Cold Fusion program. I believe the cfm to database
>communication was not that difficult, but Dave
>will have to respond specifically to that one. The larger
>issue was manipulating the flat file information from the
>main database into more of a relational database.
Do you use Access to do the above manipulation or is this handled by
SQL server (or Cold Fusion)? This seems to be a common hurdle.
At what point and with which tools should one manipulate the data.
Rarely is administrative data stored the way you need it.
Sean