CurrentProject.Connection property (Access)

Use the Connection property to return a reference to the current ActiveX Data Objects (ADO) Connection object and its related properties. Read-only Connection.

Syntax

expression.Connection

expression A variable that represents a CurrentProject object.

Remarks

Use the Connection property to refer to the Connection object of the current Microsoft Access project (.adp) or Access database object. Use the Connection property to call methods on the Connection object such as BeginTrans and CommitTrans.

Note

The Connection property actually returns a reference to a copy of the ActiveX Data Object (ADO) connection for the active database. Thus, applying the Close method or in anyway attempting to alter the connection through the Connection object's methods or properties will have no affect on the actual connection object used by Microsoft Access to hold a live connection to the current database. Because the Connection property is the main Shape provider connection, the following information is necessary when using this property.

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.