Login and Password. What happens if you use just one? Will that work? Make the DSN have the high level access and take the L and P out of the query. At least that might help rule out an access problem.
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:24 PM To: CF-Talk Subject: RE: Access Security Problem L & P???? (I've tried putting User Name & Password in Query and putting SystemRead in Query and CF System in ODBC def in CF Admin. Andy -----Original Message----- From: John Wilker [mailto:[EMAIL PROTECTED]] Sent: Sunday, October 13, 2002 9:17 PM To: CF-Talk Subject: RE: Access Security Problem 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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm