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 choosing 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
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.