CurrentProject.BaseConnectionString property (Access)

Use the BaseConnectionString property to return the base connection string for the specified object. Read-only String.



expression A variable that represents a CurrentProject object.


The BaseConnectionString property returns the connection string that was set through the OpenConnection method or by choosing Connection on the File menu. When making a connection, Microsoft Access project modifies the BaseConnectionString property for use with the ADO environment.


The following example displays the BaseConnectionString property setting of the current project.

Public Sub ShowConnectString() 
 Dim objCurrent As Object 
 Set objCurrent = Application.CurrentProject 
 MsgBox "The current base connection is " & objCurrent.BaseConnectionString 
End Sub

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.