Securing DB W/O Passwords

[Dingo]

Hello,

Is there any way to secure my DB without having my users type in a name and
pw? I seem to find conflicting answers by going through old posts and would
like a definitive answer. We are running '03 by the way.

I'd like to prevent access to the tables after a co-worker showed me she
could mail merged my tables in Word and get access to essentially any data
she wanted. It was quite eye opening.

 

[Joan Wild]

You can do this if you have just two groups - you as the developer, and
everyone else.

If that's the case, see http://www.jmwild.com/SecureNoLogin.htm

 

[Dingo]

Will this stop the pilferer from mail merging as well then? Thank you for
your assistance.

 

[Joan Wild]

If you secure the database, you can remove all permissions on the tables and
use RWOP queries for all data interaction. They won't be able to do a merge
with the tables then. However they would still be able to merge with any of
the RWOP queries that they have read data permissions on.

I must ask just what harm there is in doing a mail merge. It doesn't allow
them to actually change the data.

 

[Dingo]

There is data in a table that we don't want everybody to be able to view such
as emergency contact info.

Could you please explain RWOP query? Sorry for being ignorant to the
abbreviation.

 

[Joan Wild]

Sorry I meant to include a link. It stands for Run With Owner Permissions.
It is a property you set in query design (run permissions). Read more about
RWOP at
www.jmwild.com/RWOP.htm