1st time designer - security question

[Guest]

After creating my first database and putting it on the network, it only asks
me for my name and password. Everyone else gains immediate access. I
created 2 users and passwords. One user is me which I put in the admin group
and made me the owner of all objects. The other user was put in the users
group with limited permissions. This database is on a Novell network where
access is gained through an app that I created. The app points at the
database containing all my interface objects - forms, querys, etc.

Why does the database ask me for name and password but no one else?

 

[Rick B]

You did not follow the instructions in the security FAQ. You can't take
shortcuts. All you did was secured yourself out of the database. Anyone
else can gain full access because they are using their default SYSTEM.MDW
and signing in as ADMIN. Since you did not follow all the instructions,
ADMIN has full rights.

Go back and follow all the instructions.

Rick B

 

[Guest]

If you could enlighten me i would appreciate it. I read a FAQ that seemed to
pertain to my problem ( #40) re:users from other workgroups being able to
access a database that was supposedly secure. I followed the directions in
that faq - it said to log on as an admin user and copy all the objects to a
new database. I did this but it had no effect. I was still able to access
the database from a different computer without a password. Why is this
machine dependent?

 

[Joan Wild]

If you could enlighten me i would appreciate it. I read a FAQ that
seemed to pertain to my problem ( #40) re:users from other workgroups
being able to access a database that was supposedly secure. I
followed the directions in that faq - it said to log on as an admin
user and copy all the objects to a new database. I did this but it
had no effect. I was still able to access the database from a
different computer without a password. Why is this machine dependent?

It is essential that you follow exactly the steps outlined in the FAQ, or
your database won't be secure. You missed a step. If you do it right, they
won't be able to even open the database unless they use the right workgroup
file.

Try the detailed steps outlined at
www.jmwild.com/AccessSecurity.htm

 

[Rick B]

Here are several sources to help you secure your database. You need to
START OVER AND FOLLOW ALLLLLL INSTRUCTIONS.

Security FAQ

http://support.microsoft.com/?id=207793



The Security Whitepaper is also worth reading to help you understand.

http://support.microsoft.com/?id=148555



Joan Wild:

www.jmwild.com/AccessSecurity.htm



Lynn Trapp

http://www.ltcomputerdesigns.com/Security.htm

 

[Guest]

I followed the steps on your website, but could not get past #13. I could
not copy most of my objects to the new database - getting a " ...you do not
have rights..." type error. I did notice that after doing the first 13 steps
that my original database has an "unknown" owner for all objects ( I was the
previous owner). Is this why I can't copy objects? Not only can't I copy
objects over, but I can no longer change permissions or anything else keeping
me in a perpetual no-win state. Any suggestions??

Nick Dunwoodie

 

[Grumpy Old Man]

Not only can't I copy
objects over, but I can no longer change permissions or anything else
keeping me in a perpetual no-win state. Any suggestions??

Go back to your backup copy and try the example on my website.

www.keithwilby.com

 

[Guest]

What if the backup is gone?

Go back to your backup copy and try the example on my website.

www.keithwilby.com

 

[Grumpy Old Man]

What if the backup is gone?

Well, sadly, you may have learned the hard way to always work on copies of
your files when applying user-level security. It is extremely easy to deny
yourself admin permissions.