Directory permissions? Must have SYSTEM permissions ================================ This address is filtered through the open relay database at http://www.ordb.org and is virus scanned by ANTIVIR http://www.dwhite.ws mailto:[EMAIL PROTECTED] ================================ ----- Original Message ----- From: "Andy Ousterhout" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Sunday, October 13, 2002 9:07 PM 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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm