Re: blocking access to more than 1 user

Tech-Archive recommends: Speed Up your PC by fixing your registry

I can't see why you would want to do this, but...

The simplest way is to use Network Rights. Restrict all the users from
having CREATE rights to the DIRECTORY where the application resides.
Without CREATE rights, Access cannot create the LDB (locking) file and any
other instance of Access that tries to open the database will think it has
been opened Exclusively. Others can open it, but in Read-Only mode.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L



"JT" <JT@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:23ECF989-82C9-4A94-9B11-D14C91DFCD61@xxxxxxxxxxxxxxxx
> Is it possible to program Access so only 1 user at a time can use a
> particular database? If a second user tries to open the database, I would
> like them to get a message that the database is in use. Thanks
> --
> JT


.

Relevant Pages

  • Re: Error code = 4060
    ... divisional portals are running under a different app pool and identity than ... the corporate portal, and the identity of this pool, while having dbo rights ... portal's content database. ...
    (microsoft.public.sharepoint.portalserver.development)
  • Re: db_denydatawriter
    ... perhaps this also gives read write access on the database to this user? ... Resrictive permissions overrides in its own level. ... However, if she has sysadmin right, then she'll be able to modify that data. ... Is it possible she has some admin rights which override DenyWriter (though ...
    (microsoft.public.sqlserver.security)
  • Re: Complete Neophyte Question(s)
    ... No you cannot remove a login from the 'public' role. ... For rights to _use_ objects then the appropriate rights need to be granted ... GRANT SELECT ON dbo.Orders TO OrderViewers ... for a database that is supposed to be secured it is a bad idea ...
    (microsoft.public.sqlserver.security)
  • Re: SUUNTO Vyper PC i/f
    ... username and password. ... to enter the database password. ... I gained access to the data in Suunto v2 using it - but it will NOT allow ... have the rights to the program the DATA is MINE!! ...
    (uk.rec.scuba)
  • Re: "unable to lock database"
    ... rights to create the .ldb ... > file in the same folder as the .mdb. ... > I have some VB which opens a database file. ... > works if I am actually logged on as administrator. ...
    (microsoft.public.vb.database)