Very Computer

How can I lock down an access database so that it will not
allow write access if someone else has it open?  Is there
VB code that can recognize at run-time if the database is
open?  (If daoControl.Open Then ...) Something like this,
although I know the .Open won't work.

Thanks,
JF

----------------
On the connection object specify a mode
of "adModeShareDenyNone". If anyone else tries to open a
connection, they should get a open exclusive error.

ed.

Quote:>-----Original Message-----
>How can I lock down an access database so that it will
not
>allow write access if someone else has it open?  Is there
>VB code that can recognize at run-time if the database is
>open?  (If daoControl.Open Then ...) Something like this,
>although I know the .Open won't work.

>Thanks,
>JF
>.

-----------------
sorry, my bust, i thought you were using ADO and after i
sent the response, i realized you were using DAO. I'll
have to look it up, but i bet you specify the open mode in
the opendatabase() function.

ed.
-----------------

Quote:>-----Original Message-----
>How can I lock down an access database so that it will
not
>allow write access if someone else has it open?  Is there
>VB code that can recognize at run-time if the database is
>open?  (If daoControl.Open Then ...) Something like this,
>although I know the .Open won't work.

>Thanks,
>JF
>.

------------------------
Looks like you have to specify the parameter in a
recordset object of the. The openrecordset() method has a
options parameter wher you can us "dbDenyRead" on the
recordset. This means that other users can't get to the
tables/fields specified in your recordset query, however,
they can get to other parts of your DB.

Hope this helps.
Ed.
--------------------

Quote:>-----Original Message-----
>How can I lock down an access database so that it will
not
>allow write access if someone else has it open?  Is there
>VB code that can recognize at run-time if the database is
>open?  (If daoControl.Open Then ...) Something like this,
>although I know the .Open won't work.

>Thanks,
>JF
>.

adModeShareDenyNone won't work with a DAO connection.  I
would use ADO but it does not have some of the
functionality that I like in DAO.

Quote:>-----Original Message-----
>----------------
>On the connection object specify a mode
>of "adModeShareDenyNone". If anyone else tries to open a
>connection, they should get a open exclusive error.

>ed.

>>-----Original Message-----
>>How can I lock down an access database so that it will
>not
>>allow write access if someone else has it open?  Is
there
>>VB code that can recognize at run-time if the database
is
>>open?  (If daoControl.Open Then ...) Something like
this,
>>although I know the .Open won't work.

>>Thanks,
>>JF
>>.

>.