CurrentProject.BaseConnectionString property (Access)

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

Syntax

expression.BaseConnectionString

expression A variable that represents a CurrentProject object.

Remarks

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.

Example

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.