Database Security

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have sent up security on my database, however, others can get into the
database under their own workgroup file. What am I doing wrong in protecting
my database? I have read articles and tips, however, they are vague and I
cannot figure out how to keep others out unless they are in my workgroup.
 
 
Hi, Ronnie.
What am I doing wrong in protecting
my database?
Click to expand...

If you're using the Access 2000 Security Wizard, then you're using the wrong
version! It has bugs in it, so manually securing the database file is
required. Otherwise, the most common reason a database is not secured is
allowing the default Admin user to have any permissions. But don't feel bad.
Most people miss a step or two the first dozen or 20 times or so. For more
information on implementing User-Level Security, please see the following Web
page for the Security FAQ:

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

Study it and practice on a copy of your database several times before
implementing security on the real thing. Remember that _all_ steps listed in
the SecFAQ are required, so don't skip any of them.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blog: http://DataDevilDog.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact info.
 
Should I delete the ADMIN user?
--
Ronnie


'69 Camaro said:
Hi, Ronnie.


If you're using the Access 2000 Security Wizard, then you're using the wrong
version! It has bugs in it, so manually securing the database file is
required. Otherwise, the most common reason a database is not secured is
allowing the default Admin user to have any permissions. But don't feel bad.
Most people miss a step or two the first dozen or 20 times or so. For more
information on implementing User-Level Security, please see the following Web
page for the Security FAQ:

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

Study it and practice on a copy of your database several times before
implementing security on the real thing. Remember that _all_ steps listed in
the SecFAQ are required, so don't skip any of them.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blog: http://DataDevilDog.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact info.
Click to expand...
 
I've been to all of these. The answers are vague and they haven't helped.
 
Hi, Ronnie.
Should I delete the ADMIN user?
Click to expand...

You can't. However, you can remove it from the default Admins group if it's
currently a member. Also, ensure that the default Users group has no
permissions on anything, not even to open the database (Open/Run Database
permission). Another common mistake is to make Admin the original owner of
the database, and then make another user the owner later and remove the
Admin user's permissions. This doesn't work, because the original owner
keeps a lot of permissions. So ensure that the database owner is originally
a user who is a member of the group Admins.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blog: http://DataDevilDog.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.
 
Do you know of any online advanced classes where there might be chat rooms to
get answers?
 
Hi, Ronnie.
Do you know of any online advanced classes
Click to expand...

They don't teach User-Level Security. It's a specialized area that few
venture into, and even fewer succeed in securing the database the first
dozen times or so.
where there might be chat rooms to
get answers?
Click to expand...

That's called "online tech support." Have your credit card ready, because
you'll usually pay by the minute. You'll spend quite a bit of money before
you discover the expert may know Access fairly well, but is fairly clueless
about User-Level Security. You'll probably pay less for phone tech support,
but you'll likely get the same result. You'll just realize a little faster
that your expert doesn't know about User-Level Security.

Ask specific questions in the newsgroups, and we'll answer them for you. No
charge. Several Access experts who specialize in User-Level Security answer
questions in the Microsoft.Public.Access.Security newsgroup and have
successfully implemented User-Level Security _many_ times, in all sorts of
common or unusual circumstances. So chances are very high that whatever
problems you're encountering, experts in the Access newsgroups can explain
how to fix them.

Or, if you're in a major city, there may be an Access User Group nearby,
where someone can work with you one-on-one after the meetings.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blog: http://DataDevilDog.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.
 
Thanks for your help. I guess I'll try and post more specific questions as I
go through the process of trying to secure this database.
 
You must log in or register to reply here.

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

Linking a table from a Secure database 7
access 2000 workgroup security question 2
Secure Database 13
Opening a secured database on Access 2007 3
Workgroups Link 3
Security Wizard Problem 1
Security and encryption issues when trying to convert to 2007 1
Secure Access Database 1

Back
Top