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