Is This Possible?

  • Thread starter Thread starter Melissa
  • Start date Start date
M

Melissa

I have a database whose records are the source for a
number of Microsoft Word generated mailings - letters,
envelopes and labels.

I do not want the secretary to have any access to the
database...but I need her to be able to do these mailings
for me.

In Word Mail Merge, she will need to link the letter to a
data source (in this case a query in my database). The
query she links to will change depending on the content
of the letter. But the query will already exist, i.e.,
she will not need to create queries.

Is this possible to completely lock her out of the
database except for performing this function?

Thanks in advance.
 
You could do this using Access user-level security, and so-called "Run With
Owner Permissin (RWOP)" queries.

In outline, you would have to secure the database using the methods
described in the Access Security FAQ. (Google for links: it's always being
menioned here.) Then you would have to ensure that the database was accessed
via a user who did not have read-permission on the tabes in question. They
need only have read-permission to appropriate RWOP queries. Then they could
run those queries, but they could not view the tables directly, or make any
changes to table data.

*Unfortunately*, the learning curve to do this will be very steep, with many
traps for the unwary. You would need to treat "learning access security" as
a whole project in its own right. You would need to allocate *at least
several weeks*, and probably longer, to get a good handle on it.

HTH,
TC
 
There is a document on the website in my signature that may help with
your understanding of user-level security.

Thanks for the help and the warning! I guess I will start
studying.....
Click to expand...


=======================================================
Jack MacDonald
remove UPPERCASE LETTERS from email address
Vancouver, B.C. Canada
Info about MSAccess user-level security
www.geocities.com/jacksonmacd
 
Back
Top