[AccessD] Exclusive connection

Charlotte Foust cfoust at infostatsystems.com
Wed Jul 30 13:47:36 CDT 2003


I know, Mark, but they lie.  adModeRead turns off any locks on the
connection.  And if I open a connection using adShareExclusive, then I
can't use OpenSchema against it!  Grrr!

Charlotte Foust

-----Original Message-----
From: Mitsules, Mark [mailto:Mark.Mitsules at ngc.com] 
Sent: Wednesday, July 30, 2003 10:38 AM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] Exclusive connection 


Charlotte,

From: 

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dndao/h
tml/
daotoadoupdate_topic4.asp


Sub ADOOpenJetDatabaseExclusive()

   Dim cnn As New ADODB.Connection

   cnn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
      "Data Source=.\NorthWind.mdb;Mode=" & adModeRead
   cnn.Close

End Sub



Mark


-----Original Message-----
From: Charlotte Foust [mailto:cfoust at infostatsystems.com] 
Sent: Wednesday, July 30, 2003 2:24 PM
To: AccessD at databaseadvisors.com
Subject: [AccessD] Exclusive connection 


Does anyone know how to use an ADO connection to lock a database so that
no one else can log into it?  Making the connection is no problem, but
is it possible to make that connection entirely exclusive?

Charlotte Foust
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


More information about the AccessD mailing list