The option shows up on the very last screen when you select tables. > -----Original Message----- > From: Charlie Griefer [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, January 01, 2003 3:49 PM > To: CF-Talk > Subject: Re: connecting to linked ODBC data... > > > ----- Original Message ----- > From: "Samuel Neff" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Wednesday, January 01, 2003 12:36 PM > Subject: RE: connecting to linked ODBC data... > > > > You can have Access store the username/password in the > links. There > > is a checkbox when setting up the links that says store > > username/password. > > > > If you're not joining on Access tables, you're better off > querying the > > oracle tables directly, instead of going through an Access link. > > Hi Sam: > > unfortunately, there are a number of situations where I do > need to join :\ > > i saw the option to store the username in the ODBC link...i > did not see the option to store username and password. We > are using Access '97 (if that matters....and yes, i know, i know) :) > > 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 Get the mailserver that powers this list at http://www.coolfusion.com