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 clicking 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