Re: Securing an Access 2000 database

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?

--
Joan Wild
Microsoft Access MVP
"geocoy" <geocoy@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:4BC0B77C-EDB9-47C2-BBC3-BA3F98D017A4@xxxxxxxxxxxxxxxx
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" wrote:

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)

--
Joan Wild
Microsoft Access MVP
"geocoy" <geocoy@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:F61D4FD2-2E99-4353-844C-40E0A52E0174@xxxxxxxxxxxxxxxx
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" wrote:

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

--
Joan Wild
Microsoft Access MVP
"geocoy" <geocoy@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:277987F1-AF04-4365-BFB5-E30700A07A58@xxxxxxxxxxxxxxxx
I am using the FAQ *** 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








.

Loading