hey all... i'm currently connecting to an Access .mdb file...which has linked tables in it. The linked tables are linked to an Oracle database, which requires a username and password.
the .mdb file itself is not password protected. So...if I do not pass username/password attributes in my <cfquery> tag, I can get to the Access tables fine...but not the linked tables. If I *do* pass username/password attributes in my <cfquery> tag, well...same thing :) Apparently, Access doesn't take the username/password and pass it to the Oracle tables when prompted for authentication. Any easy solution that I'm overlooking? thx, Charlie ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm