Two Simple Questions on Security

[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

 

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

 

[Anthony Bollinger]

Thanks for the indicators, I'll give it a whirl! --Tony

 

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

 

[Keith Wilby]

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