CurrentProject.BaseConnectionString Property (Access)
You can 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 clicking 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