Home All Groups Group Topic Archive Search About

Two Simple Questions on Security

Author
15 Oct 2007 8:13 PM
Anthony Bollinger
1. Does the standard security FAQ available from MS and other sources, which
states it applies through Access 2000, apply equally to 2002 and 2003?

2. If I secure a database according to the security FAQ, how can I be sure
or know if it is secure against data access using ODBC and similar
technologies?

Thanks!
Tony

Author
15 Oct 2007 8:36 PM
'69 Camaro
Hi, Tony.

> 1. Does the standard security FAQ available from MS and other sources,
> which states it applies through Access 2000, apply equally to 2002 and
> 2003?

Yes.  And better yet, securing the database with the Security Wizard for
those later versions actually secures it, unlike the Access 2000 Security
Wizard, which leaves the members of the Users group with permissions (i.e.,
an unsecured database).

> 2. If I secure a database according to the security FAQ, how can I be sure
> or know if it is secure against data access using ODBC and similar
> technologies?

You test it.  On someone else's computer.  With the wrong Workgroup
Information File.  Did Access allow you to open it?  If it did, then the
database is not secured, because you missed some steps.  (If so, don't feel
bad.  Most of us had to practice quite a few times before we finally got it
right.)

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.
Author
17 Oct 2007 8:44 PM
Anthony Bollinger
Thanks for the indicators, I'll give it a whirl!  --Tony
Author
18 Oct 2007 6:55 AM
'69 Camaro
> Thanks for the indicators, I'll give it a whirl!  --Tony

You're welcome.  If you have any further questions, you know where to come
back to!

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.
Author
18 Oct 2007 7:59 AM
Keith Wilby
"Anthony Bollinger" <ton***@DONTsendto.org> wrote in message
news:eTxCPf2DIHA.5856@TK2MSFTNGP04.phx.gbl...
> 1. Does the standard security FAQ available from MS and other sources,
> which states it applies through Access 2000, apply equally to 2002 and
> 2003?
>
> 2. If I secure a database according to the security FAQ, how can I be sure
> or know if it is secure against data access using ODBC and similar
> technologies?
>

Just to add to Gunny's response, Access security is good but is it breakable
by determined hackers with the right tools.  If your data is sensitive and
there is a risk then use something else.

Keith.
www.keithwilby.com

AddThis Social Bookmark Button