In theory, you would setup a mapped network drive to the remote machine by using either the DNS name or IP address of the remote machine followed by the name of the shared drive. But if you don't have a T-1 on both ends, the connection speed may be too slow to maintain or even connect.
So, for example, if the DNS name of the remote machine was "www.fusioneers.com", and the shared drive was "public", then you'd setup a network drive with the following path: \\www.fusioneers.com\public >From there, you would select it as though the .MDB file was on your local machine >since you would have a mapped drive on your local machine. But in practice, I've never seen it work. I tried it with a DSL connection on my end (restricted to 128k upstream) with multiple T-1's on the other end and still couldn't get at it. But you may be able to if you've got a super fast connection. OK so maybe I'm better at networking than CF these days. ;) ---mark ======================================================== Mark Warrick ([EMAIL PROTECTED]) Founder, Fusioneers.com / CTO, ZapConnect.com Phone: 714-547-5386 / 714-667-0203 / Efax: 801-730-7289 http://www.warrick.net / http://www.fusioneers.com http://www.zapconnect.com ICQ: 125160 AIM: markwarric Yahoo: Serengeti ======================================================== > -----Original Message----- > From: Timothy Heald [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, June 18, 2002 11:25 AM > To: CF-Talk > Subject: RE: Getting to an Access DB on a remote machine > > > How would I do that? I have gone into data sources and looked for where I > can set it up by giving it an ip address or whatever, and I can't seem to > find it. By remote I don't mean even on the same network, maybe > not even in > the same country. > > Tim Heald > ACP/CCFD :) > Application Development > www.schoollink.net > > > -----Original Message----- > > From: Shawn Regan [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, June 18, 2002 10:13 AM > > To: CF-Talk > > Subject: RE: Getting to an Access DB on a remote machine > > > > > > 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 > > > > > > > ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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
