connectionStringAccess: Connection String Access

In KWB-R/kwb.db: Functions supporting data base access

Connection String Access

Description

Connection String Access

Usage

connectionStringAccess(mdb, uid = "", pwd = "", globalPartialBulkOps = 0)

Arguments

mdb	full path to MS Access file
uid	user id, if any
pwd	password, if any
globalPartialBulkOps	A Long value (read/write) that determines the behavior of the Jet database engine when SQL DML bulk operations fail. When set to allow partial completion of bulk operations, inconsistent changes can occur, because operations on some records could succeed and others could fail. When set to allow no partial completion of bulk operations, all changes are rolled back if a single error occurs. The Jet OLEDB:Global Partial Bulk Ops property setting can be overridden for the current Recordset object by setting the Jet OLEDB:Partial Bulk Ops property.The Jet OLEDB:Global Partial Bulk Ops and Jet OLEDB:Partial Bulk Ops properties can be set to any of the following values: Default = 0, Partial = 1, No Partial = 2

References

http://msdn.microsoft.com/en-us/library/office/aa140022%28v=office.10%29.aspx

KWB-R/kwb.db documentation built on Oct. 1, 2023, 4:10 a.m.