It all depends if they need disconnected access to the data in Access. I would still like to hear the reason not all of the data can be moved to SQL.
I, too, use Access data projects where Access becomes the interface to the SQL data and nothing more. It makes it very easy to let others maintain data w/o needing to create an entire web administration interface just for one or two people. M!ke -----Original Message----- From: Connie DeCinko [mailto:[EMAIL PROTECTED] Sent: Friday, March 25, 2005 10:25 AM To: CF-Talk Subject: RE: Combininig Datasources in 1 CFQUERY You don't even have to do that. Just create ODBC datasources to your SQL Server tables and edit your Access reports to use the SQL Server data. I have a couple apps like this. Access does nothing more than provide forms and reports. All data resides outside of Access. -----Original Message----- 1. You could convert everything to SQL, then just export to Access when you need to if you are simply reporting from Access. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:200047 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
