Blocking Access tables from other Office apps

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dennis - 29 Aug 2006 17:37 GMT

I need to know if there's a way to block other MS Office applications (Word,
Excel, etc) from being able to extract data from Access tables. Does anyone
out there know of a way to do that? Failing that, what about encryption
options?

Reply to this Message

jacksonmacd - 30 Aug 2006 05:27 GMT

You can keep out casual users by applying User Level Security, but it
will not keep out a determined hacker. If your goal is bullet-proof
security, then Access may not be sufficient.

Access user security is not to be taken lightly, so read very
carefully and thoroughly, practice on a COPY of your database, and
don't skip any steps in the process.

Here are a number of links about security:

http://home.bendbroadband.com/conradsystems/accessjunkie/resources.html#Security

>I need to know if there's a way to block other MS Office applications (Word,
>Excel, etc) from being able to extract data from Access tables. Does anyone
>out there know of a way to do that? Failing that, what about encryption
>options?

--
jackmacMACdonald@telusTELUS.net
remove uppercase letters for true email
http://www.geocities.com/jacksonmacd/ for info on MS Access security

Reply to this Message