Are you doing both? L and P in the query and L and P in the DSN? Maybe you can't do that?
J. John Wilker Web Applications Consultant, Writer Macromedia Certified ColdFusion Developer Founder/President IE CFUG www.red-omega.com Whatever is wrong it is better than a poke in the eye with a sharp stick. Unless of course you just got poked in the eye with a sharp stick. -----Original Message----- From: Andy Ousterhout [mailto:[EMAIL PROTECTED]] Sent: Sunday, October 13, 2002 7:08 PM To: CF-Talk Subject: RE: Access Security Problem Yes, I've added User Name and password to the query. I must be missing something else... -----Original Message----- From: John Wilker [mailto:[EMAIL PROTECTED]] Sent: Sunday, October 13, 2002 9:04 PM To: CF-Talk Subject: RE: Access Security Problem Do you provide login info in the DSN definition? I think that is where you would have to do it, or in the query itself. Not completely sure, haven't done much with access security. J. John Wilker Web Applications Consultant, Writer Macromedia Certified ColdFusion Developer Founder/President IE CFUG www.red-omega.com Whatever is wrong it is better than a poke in the eye with a sharp stick. Unless of course you just got poked in the eye with a sharp stick. -----Original Message----- From: Andy Ousterhout [mailto:[EMAIL PROTECTED]] Sent: Sunday, October 13, 2002 6:45 PM To: CF-Talk Subject: Access Security Problem I've added security to my Access 2000 database as follows: CF System - Full Data User SysRead - Read User SysNew - New Data user SysUpt - Update Data User I've set Coldfusion login to CFSystem. When I try to do my first read using SysRead ID, I get a database error - No read permission. Any thoughts on what I might try to fix this? Andy ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
