[AccessD] Exclusive connection

Mitsules, Mark Mark.Mitsules at ngc.com
Wed Jul 30 13:38:22 CDT 2003


Charlotte,

From: 

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dndao/html/
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


More information about the AccessD mailing list