FiveTech Support Forums

All,

I want to open an ado connection to an access database using the adModeShareExclusive mode (12). Can someone give me an example for doing this?

This is what I'm using now:

oConn := CREATEOBJECT( "ADODB.Connection" )
oConn:Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+cDataSource)

cDataSource is the path and name of my .mdb file. The above works fine. I can get the mode with oConn:Mode, which returns 16. However I cannot find the correct syntax to specify or set the mode.

Thanks,
Randal

Probably you are trying to set Mode property when the connection is open. From MSDN:

You can set the Mode property only when the Connection object is closed.

EMG

Enrico,

Thanks, that helps.

Randal