Securing an Access 2000 database

[geocoy]

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

 

[geocoy]

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?

 

[Joan Wild]

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'.

 

[geocoy]

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

 

[Joan Wild]

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)

 

[geocoy]

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!!

 

[Joan Wild]

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?

 

[geocoy]

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