BaseConnectionString Property [Access 2003 VBA Language Reference]

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


expression Required. An expression that returns one of the objects in the Applies To list.


The BaseConnectionString property is available only by using Visual Basic and is read-only.

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

Applies to | CodeProject Object | CurrentProject Object

See Also | ConnectionString Property | OpenConnection Method