Connection Object Record Mode Property Stream Mode Property PROPERTY:  Connection::Mode ConnectModeEnum = connectionobject.Mode connectionobject.Mode = ConnectModeEnum The Mode property dictates the provider access permissions for an open connection. It must be set before the connection is opened. This property sets or returns the ConnectModeEnum value. The default is adModeUnknown or zero.   ConnectModeEnum Constants   Constant Value Description adModeUnknown 0 Permissions cannot be set or determined adModeRead 1 Read-only adModeWrite 2 Write-only adModeReadWrite 3 Read and write permissions adModeShareDenyRead 4 Prevents other connections from having read permissions adModeShareDenyWrite 8 Prevents other connections from having write permissions adModeShareExclusive 12 Prevents opening other connections adModeShareDenyNone 16 Permits opening other connections with read/write permissions adModeRecursive 0x400000 Used in conjunction with the *ShareDeny* constants to set permissions on sub-records   Code (VBScript): Set objConnection = Server.CreateObject("ADODB.Connection") objConnection.Mode = adModeRead objRecordset.IsolationLevel = adXactIsolated ... objConnection.Open strConnect Copyright 1999-2001 by Infinite Software Solutions, Inc. All rights reserved. Trademark Information