AccessConnection Property
You can use the AccessConnection property to return a reference to the current Microsoft ActiveX Data Objects (ADO) Connection object and its related properties. Read-only Connection.
expression.AccessConnection
expression Required. An expression that returns one of the objects in the Applies To list.
Remarks
The AccessConnection property returns an ADO connection that uses two OLE DB providers. It uses the Microsoft OLE DB Provider for Microsoft Jet (Microsoft.Jet.OLEDB.4.0) as the data provider and the Microsoft OLE DB Provider for Microsoft Access 10 (Microsoft.Access.OLEDB.10.0) as the service provider.
You should use the AccessConnection property if you intend to create ADO recordsets that will be bound to Access forms. The form will not be updateable unless it is created by using the OLE DB Provider for Microsoft Access 10, even if the recordset is updateable in ADO.