CurrentProject.BaseConnectionString Property

Access Developer Reference

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:

Visual Basic for Applications
  Public Sub ShowConnectString()

    Dim objCurrent As Object

    Set objCurrent = Application.CurrentProject
    MsgBox "The current base connection is " & objCurrent.BaseConnectionString

End Sub