Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Security / May 2007

Tip: Looking for answers? Try searching our database.

hide BE mdb so user cannot use Windows Explorer to find it

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Song Su - 27 May 2007 18:42 GMT
My BE .mdb is in network shared folder. Is it possible to hide BE .mdb so
users cannot use Windows Explorer to find it but still be able to use my
application which splits FE and BE where FE is in C: and BE is in network
shared folder?

IT staff told me they are using Microsoft Active Directory to manage users
and groups on the network.

Thanks.
Scott McDaniel - 27 May 2007 19:38 GMT
>My BE .mdb is in network shared folder. Is it possible to hide BE .mdb so
>users cannot use Windows Explorer to find it but still be able to use my
>application which splits FE and BE where FE is in C: and BE is in network
>shared folder?

I'm using Windows XP, SP2, and when I right click on a file and select Properties, one of the Attributes is Hidden ...
perhaps this would work for what you want? Of course, if users are allowed to manipulate their machine settings they can
tell Explorer to show hidden files, so this may not work for all users.

You can also rename the file to whatever you wish (something like bmcwln.dll or something equally odd). Access doesn't
care what it's named, after all, and users would be far less likely to click on those files (at least in theory).

Your other post indicates that you're trying to "secure" your database, without using ULS. While ULS has it's flaws,
it's still the best method to use to keep users out of your application.

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com
david@epsomdotcomdotau - 28 May 2007 00:04 GMT
> My BE .mdb is in network shared folder. Is it possible to hide BE .mdb so
> users cannot use Windows Explorer to find it but still be able to use my

You need to remove 'browse' permission from the file.

Get IT to remove inheritable browse permission from the
folder as well, so that when you compact the file you don't
loose the permission setting.

Check this anyway after doing a compact/repair, because
some versions incorrectly inherited their permissions from
the users temp folder.

For best efficiency, the folder should be as near to the root
of the drive as possible, and there should be a share directly
on the folder. Users should have the "Bypass traverse checking"
privilege.  SMB packet signing should be turned off on the file
server.

(david)

> My BE .mdb is in network shared folder. Is it possible to hide BE .mdb so
> users cannot use Windows Explorer to find it but still be able to use my
[quoted text clipped - 5 lines]
>
> Thanks.
Tony Toews [MVP] - 28 May 2007 20:50 GMT
>My BE .mdb is in network shared folder. Is it possible to hide BE .mdb so
>users cannot use Windows Explorer to find it but still be able to use my
>application which splits FE and BE where FE is in C: and BE is in network
>shared folder?

Any techniques you can try can likely be broken somehow.   If you
truly require rock solid security, such as a legislated requirement,
then I'd suggest moving to SQL Server.

Tony
Signature

Tony Toews, Microsoft Access MVP
  Please respond only in the newsgroups so that others can
read the entire thread of messages.
  Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
  Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.