CurrentProject.BaseConnectionString Property (Access)

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


expression. BaseConnectionString

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

See also

CurrentProject Object