You can create a DSN on the CF machine that points the access file on the remote machine.
Shawn Regan -----Original Message----- From: Timothy Heald [mailto:[EMAIL PROTECTED]] Sent: Monday, June 17, 2002 10:02 PM To: CF-Talk Subject: Getting to an Access DB on a remote machine Hey, I was wondering if anyone knew how to get CF to talk to an access DB on a remote machine? Here's my thing. Client buys products from vender. Vender has product list in an access db. Client wants to be able to automatically update it's available product line without waiting for updates. Now I am thinking there should be an easy way to register the Access db as an odbc data source, then on clients machine use that. But I can't seem to find a straight ODBC driver. Seems to be all product specific. We need this to be able to go to MX, so no dns-less connections or whatever. I am sorry if this is something I should know how to do. I don't often work with windows based servers, and almost never with Access when I do. TIA Tim ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
