To date my CF apps have been on a server on our campus network. That makes it simple to get to the data with MS Access.
I'm working on a couple of apps that will be hosted on a commercial server so I'll be ftping to it. I've split my data into two databases - one that will not be written to (but read) by users that we can change by putting a new database up on the site. The response data from the users goes into a separate database that will accumulate data over years. Before I come up with a solution somewhere between elegant and klunky to get this data - what do you do? (I've thought of ftping the entire database down but see some problems with that, especially as it ages and gets bigger.) Larry V. Stephens Office of Risk Management 812-855-9758 [EMAIL PROTECTED] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:198669 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54