this is a real PITA. Access is not designed for this. Unless something has changed in recent MDACs, you can't create an Access DSN to point to another server. I was able at one time to hack the reg settings to force this, but then ran into many permissions problems over time, so we ditched the idea.
Doug >-----Original Message----- >From: Shannon Carr [mailto:[EMAIL PROTECTED]] >Sent: Thursday, October 10, 2002 1:40 PM >To: CF-Server >Subject: Access network ODBC connection > > >I am having a problem with CF Server verifying an ODBC >connection that looks >to another server for a MS Access table. I have done this >successfully with >SQL Server 2000 but Access fails. Any help would be appreciated. > >Thanks, >Shannon > > >Shannon Carr >Terralogic, Inc. >116 N. Central Ave. >Staunton, VA 24401 >(540) 213-2447 >(540) 213-2449 (fax) >www.gislogic.com > > >****** CONFIDENTIALITY NOTICE ****** > >This communication and the information it contains is intended for the >person or organization to whom it is addressed. Its contents are >confidential and may be protected in law. Unauthorized use, copying or >disclosure of any of it may be unlawful. If you are not the intended >recipient, please contact us immediately. > > ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com ------------------------------------------------------------------------------ To unsubscribe, send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body or visit the list page at www.houseoffusion.com
