CF5, and no, I did not create a new workgroup file. I noticed that I can't create a new, "unsecured" database. I'll go through the process of resetting. Hopefully, the Access support site will have instructions on doing so.
How do I identify the new workgroup file to CF5? Thanks to everyone who helped me late last nite. Andy -----Original Message----- From: Samuel Neff [mailto:[EMAIL PROTECTED]] Sent: Monday, October 14, 2002 8:02 AM To: CF-Talk Subject: Re: Access Security Problem Andy, Did you create a new workgroup file to store the security information? If not, you should remove all security from the database (since the users are in the system workgroup file and this can cause problems with all other databases on your system). Ideally, you'll want to restore an original workgroup file from the CD, but export all your data first since you might lose access to it. If you did create a new workgroup file, did you identify the workgroup file when setting up the ColdFusion datasource? Also, are you using CF5 or CFMX? If CFMX, are you using the Microsoft Access driver or ODBC Socket driver? If you haven't read it, please download and read the Access 2000 Security Whitepaper. http://support.microsoft.com/default.aspx?scid=kb;en-us;Q305541 ---------------------------------------- Samuel R. Neff Senior Software Engineer B-Line Express Advanced ColdFusion 5.0 Certified Team Macromedia Volunteer for ColdFusion ---------------------------------------- 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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm