 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Security / February 2007Securing an Access 2000 database
I am using the FAQ sheet for securing a database. I created a new workgroup file and set up password protection. I created my own account as the Admins user. Then I created a new database and imported all the objects from my source database (unsecured database). At this point I checked the database, it works fine. But when I tried to assign user level premissions, I lose the code behind my forms. This is the first time I have ever had a problem like this. I also tried using the Security Wizard, it gives the same results Any one know a fix for this Well since there are no takers, I thought I would tell you that when I try to view the code behind the forms, Access gives me an error message that Access lost it connection the the network and some data may be lost. The application and the work group file are on my local PC. I am on a corporate network, but I can't think of any reason the network might influence the activity of setting the permissions. Any ideas? > I am using the FAQ sheet for securing a database. I created a new workgroup > file and set up password protection. I created my own account as the Admins [quoted text clipped - 5 lines] > > Any one know a fix for this I have never heard of such a thing. Are you saying to assign some group permission to open a form, you then open the form and view the code and it's empty - or it doesn't work? What do you mean by 'lose the code'.  SignatureJoan Wild Microsoft Access MVP >I am using the FAQ sheet for securing a database. I created a new >workgroup [quoted text clipped - 10 lines] > > Any one know a fix for this The database is fully functional with all of my code behind the forms. Then I try to set up a secure database and assign group permissions. As soon as I assign a group permissions to access certain forms for instance, the application fails. When I started checking to see what the problem might be, I opened a form in design view and tried to view the code. In the process of trying to view the code is when I get a messsage that the application has lost connection to the network (probably a bogus message, since I have the application and the work group file on my pc). But the result is the same, I have lost connection to the code that was driving my forms. I've tested this several different ways and the result is always the same. In my first attempt, I used the Wizard, and when it failed, I blamed it on the Wizard. So then I tried assigning permissions manually, and the result was the same. So then I tried it again and all I did was view the permissions assigned to the Admins and sure enough when I was done viewing, I had lost connection to my code. I am at a loss for ideas. I have entertained possibble ideas: 1) This is corporate software I am using, so I may not have a complete installation. I hope that is not the problem because IT is real slow about responding to these issues. 2) It could be something on the network is causing a problem, but I can't imagine what it would be. 3) I am taking a copy of this database home with me to test it at home, I am betting I will not have the problem at home, but when I bring it back to work, will the problem resurface? Ideas appreciated > I have never heard of such a thing. Are you saying to assign some group > permission to open a form, you then open the form and view the code and it's [quoted text clipped - 16 lines] > > > > Any one know a fix for this It sounds like a problem with the database, not security (although that may be bringing to the forefront). When you say 'application' are you referring to a single mdb or a split mdb (and application meaning frontend)? Have you compiled the application (Debug, Compile) with no errors? Have you compacted? (by the way, don't use the security wizard in 2000 as it is flawed) SignatureJoan Wild Microsoft Access MVP > The database is fully functional with all of my code behind the forms. > Then [quoted text clipped - 58 lines] >> > >> > Any one know a fix for this Well I am trying this post again, the first one failed I made a fresh copy of the database and compiled it with no errors Then I compacted it, with no errors Then I created a new database and imported all of the objects from the compiled database. Then I compiled this new database and compacted the new database Then I assigned group permissions to the Admins user Then I checked the application to see if it was having any problems. There were no apparent problems. So I checked it to see if I could still view the code. I was able to see and work with the code So I assigned permissions to the next group and there are no apparent problems. At this point it looks like problem solved. I will continue to test it Thanks to Joan Wild!! > It sounds like a problem with the database, not security (although that may > be bringing to the forefront). [quoted text clipped - 69 lines] > >> > > >> > Any one know a fix for this Something I don't understand. "Then I assigned group permissions to the Admins user" What does this mean? The Admins Group will automatically get full permissions to everything. The Admin user shouldn't have any permissions. Can you explain? SignatureJoan Wild Microsoft Access MVP > Well I am trying this post again, the first one failed > I made a fresh copy of the database and compiled it with no errors [quoted text clipped - 106 lines] >> >> > >> >> > Any one know a fix for this You are correct, but I went in and viewed them as a test. When I did this on previous attempts, viewing the permissions was all it took to make it fail. Then I added a second group permissions to continue the test to see if it was still functional. So I think it is okay. I will continue to test it Thanks > Something I don't understand. > "Then I assigned group permissions to the Admins user" [quoted text clipped - 112 lines] > >> >> > > >> >> > Any one know a fix for this |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.