I copied the following code from one of the connection string, generated by VS 2005, when I connected to a Access DB with server explorer, using OLEDB data provider:
"Jet OLEDB:Global Partial Bulk Ops=2;" & _
"Jet OLEDB

"Jet OLEDB

"Mode=Share Deny None;Jet OLEDB:Encrypt Database=False;" & _
"Jet OLEDB:Create System Database=False;" & _
"Jet OLEDB

"Jet OLEDB:Compact Without Replica Repair=False;" & _
"Jet OLEDB:Global Bulk Transactions=1;"
Can anyone explain this string I am not asking about the parameters, like what is Locking Mode. What I am asking is whether Locking Mode=1 locks the DB with Pessimistic or Optimistic Locking protocal
Moreover, I need to tweak my application performance. So, can somebody point me to a resource that enumerates & explain all parameters that can be set in this string