Mode

Specifies access permission to the OLE DB data provider.

When to specify Mode You must specify the Mode parameter before connecting to the database.

Mode = 'value'

Parameter	Description
value	Specifies access permission to the OLE DB data provider. Values are: Deny read share Prevents other users from opening in read mode. Deny write share Prevents other users from opening in write mode. Exclusive share Prevents other users from opening in read/write mode. No share deny Neither read nor write access can be denied to other users. Read/Write Allows read/write access. Read-only Allows read access. Write-only Allows write access.

Parameter

Description

value

Specifies access permission to the OLE DB data provider. Values are:

None

To allow other users read/write access to the OLE DB data provider:

Database profile On the Transaction tab in the Database Profile Setup dialog box, select Read/Write from the Mode list box.

Application Type the following in code:

SQLCA.DbParameter="MODE='DB_MODE_READWRITE'"