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