Secured database is not secure


A

Angela

I've created an Access 2000 database and used the wizard to create multiple
user/group security accounts and passwords. I removed the Admin user from
the Admins account, and made sure that the default User had no permissions.
When I use the shortcut (created automatically from the Wizard), I'm prompted
for a password etc. However, when I open the database from Explorer, I'm not
prompted for a password and have complete read/write/edit capabilities. What
did I do wrong? Why hasn't the Wizard secured the database? I understand
that when opening from Explorer, the database might be using the wrong
workgroup file to open the database but how do I prevent that from happening,
especially when others are opening the database from their workstations?
 
Ad

Advertisements

R

Rick Brandt

Angela said:
I've created an Access 2000 database and used the wizard to create multiple
user/group security accounts and passwords. I removed the Admin user from
the Admins account, and made sure that the default User had no permissions.
When I use the shortcut (created automatically from the Wizard), I'm prompted
for a password etc. However, when I open the database from Explorer, I'm not
prompted for a password and have complete read/write/edit capabilities. What
did I do wrong? Why hasn't the Wizard secured the database? I understand
that when opening from Explorer, the database might be using the wrong
workgroup file to open the database but how do I prevent that from happening,
especially when others are opening the database from their workstations?
When using the wrong workgroup the file should refuse to open. Check to make
sure that "Admin" is not the owner of any objects particularly the database
object.
 
Ad

Advertisements

A

Angela

Thank you both, that was very helpful. I did indeed have an ownership issue.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

when is a secured database not secured? 2
database security 2
secured database 3
Database security 2
Database Security 11
Securing a database 6
Secured database 4
security wizard not securing database 2

Top