Re: Can It Be Done? - MDB Security

From: Phillip Windell (_at_.)
Date: 05/27/04 

Date: Thu, 27 May 2004 08:46:53 -0500

Copying it doesn't prove anything. Copying only requires read-only
permission. You are *not* going to be able to do what you wish. Any
permission that allows the file to be written to will also allow it to be
moved or deleted.

You either need to write a separate interface (a "front-end") for the
database which requires a very high level of programming skills ($$$) then
only the interface has permission to write to the file, and the interface
will have built into it the security features to allow the users to only do
what they need.

The other solution is to migrate the data to an SQL Database. It is
possible to use the Access MDB file to create a "front-end" to the SQL
Database, otherwise you would have to write one youself.

The third option is to educate the users on how to not screw things up and
keep doing it the way you are doing it. Make daily backups of the MDB file
(just make a new copy of it somewhere,...like a CD). 

-- 
Phillip Windell [MCP, MVP, CCNA]
www.wandtv.com
"Jado" <ploxly@hotmail.com> wrote in message
news:%23ppIKD%23QEHA.3616@TK2MSFTNGP11.phx.gbl...
> Hi
> could you be a little bit more specific as there is no 'All' option that i
> can see in NTFS.  i'm using Win2000 Server.
>
> do you mean 'Full control' ?
>
> i've been playing around, but i can still copy the mdb file to my local
> system.
> are you sure it is possible?
>
>
> Thanks
> Jado
>
> "Jonathan Maltz [MS-MVP]" <jmaltz@mvps.org> wrote in message
> news:eDES0Z1QEHA.3140@tk2msftngp13.phx.gbl...
> > Hi,
> >
> > You can try setting NTFS access on the file to deny the users "All"
> >
> > -- 
> > --Jonathan Maltz [Microsoft MVP - Windows Server, Virtual PC]
> > http://www.visualwin.com - A Windows Server 2003 visual, step-by-step
> > tutorial site :-)
> > http://vpc.visualwin.com - Does <insert OS name> work on VPC 2004?  Find
> out
> > here
> > Only reply by newsgroup.  I do not do technical support via email.  Any
> > emails I have not authorized are deleted before I see them.
> >
> >
> > "Jado" <ploxly@hotmail.com> wrote in message
> > news:%23$SwJExQEHA.3052@TK2MSFTNGP12.phx.gbl...
> > > Hi
> > >
> > > Basically i need to prevent users from Copying/Moving/Deleting a MS
> Access
> > > database from it's current location.
> > >
> > > the users need Read/Write access in order to update the records within
> the
> > > database.
> > >
> > > So, is it possible for me to prevent Copying/Moving/Deleting of the
> actual
> > > file (not the records within it)?
> > >
> > > any help would be great.
> > >
> > > Thanks
> > >
> > > Jado
> > >
> > >
> >
> >
>
>

Relevant Pages

  • RE: Error 3734
    ... I'm not sure why this was posted to the "reports" news group however, ... first make sure that every user has permission to create and delete files in ... the folder containing the MDB file. ... This error message indicates that a user set the database in a mode ...
    (microsoft.public.access.reports)
  • Re: Why I can not access remote database
    ... The .mdb file is on a different machine? ... Jet database engine cannot open the file 'Unknown'. ... or you need permission to view its data. ... > (I tried creating IUSER_DBMACHINE local account on the database box, ...
    (microsoft.public.inetserver.asp.general)
  • Re: How do I backup, copy or transfer data
    ... Backing up your database can be a simple as ... ... Copying the MDB file from the hard drive to a diskette on a daily basis ...
    (microsoft.public.access.gettingstarted)
  • Re: PROBLEM WITH MY CONNECTION DATABASE
    ... Is the path to the MDB file in the error message correct? ... The fact that you have permissions on the database does not mean that the ... web-server does unless you have disabled anonymous access. ... And I have full permission because i am administrator. ...
    (microsoft.public.inetserver.asp.db)
  • Re: Replicating an Access Database
    ... copying a .mdb file would work for me. ... I've added the replication library that you suggested and the only added function that I can find is one that allows compacting a database. ... Farsad ...
    (microsoft.public.vb.syntax)