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.BaseConnectionString

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

Remarks

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.

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

Applies to | CodeProject Object | CurrentProject Object

See Also | ConnectionString Property | OpenConnection Method