can't you do that in the ODBC settings? assuming since ur using access you're also using windows.
try going to Control Panel > ODBC Datasources > User DSN > Configure > Advanced is this a bad way to do this? "Joseph DeVore" <[EMAIL PROTECTED]> on 12/21/2001 02:08:44 PM Please respond to [EMAIL PROTECTED] To: CF-Talk <[EMAIL PROTECTED]> cc: Subject: RE: Password Protecting an Access ODBC connection You said, "Already had that discussion, about not storing CC nums etc a nd encryption but they still want to store the cc info anyway. I was asked if it wa s possible to setup some sort of secure connection the DB. I haven't us ed Access outside of simple proto-typing in a long time." In the CF administrator when you add a datasource you can enter the databases password but if someone had access to the registry they could get that password in no time. Also, I didn't say don't store cc's. I said if you have to store them at I would at least encrypt them. Especially when it's easy. It only tak es a few minutes to implement encryption/decryption and can save you a heck of a lot more time, money and hassle later (oh and lawsuits).. That code I sent you in my last message works great and it would not ta ke more than a few minutes to implement. Maybe run that by them. Anyhow, good luck. - Joseph -----Original Message----- From: Duane Boudreau [mailto:[EMAIL PROTECTED]] Sent: Friday, December 21, 2001 10:46 AM To: CF-Talk Subject: Password Protecting an Access ODBC connection A colleague asked if it is possible to password protect an ODBC connect ion to an access database, but its been so long since I've used MS Access t hat cant remember. Is this possible? ______________________________________________________________________ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona 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
