Open MDB exclusively

  • Thread starter Thread starter Guy Cohen
  • Start date Start date
G

Guy Cohen

Hi all,

* Using VB6+ADO2.8 *

I tried to open an MDB file exclusively.
I got "isam component not found" -2147467259.

With CON
.Provider = "Microsoft.Jet.OLEDB.4.0;Data Source=" & gsDBFILE &
";Exclusive=1;Jet OLEDB:Database Password=12345;"
Call .Open
End with

Please advise
TIA
Guy.
 
I found the solution myself... :)

To open with exclusive, you do not need to specify exclusive=1 in the
connection string.
Before calling "call .open", use ".Mode = adModeShareExclusive"

Guy
 
Back
Top