Hi
i am not an Access GURU i just took over a project,
i am looking at the connection string and i see this code
Public Function CurDb() As ADODB.Command
If pCurDb Is Nothing Then
'recordset, command and connection variables
Dim Cnxn As ADODB.Connection
Dim strCnxn As String
' Open connection
Set Cnxn = New ADODB.Connection
strCnxn = CurrentProject.AccessConnection
Cnxn.Open strCnxn
' Open command object with one parameter
Set pCurDb = New ADODB.Command
Set pCurDb.ActiveConnection = Cnxn
End If
Set CurDb = pCurDb
End Function
i know that this code CurrentProject.AccessConnection is calling the connection
my Questions is where is that configured ? where do i change it ?
Edit / Delete
i am not an Access GURU i just took over a project,
i am looking at the connection string and i see this code
Public Function CurDb() As ADODB.Command
If pCurDb Is Nothing Then
'recordset, command and connection variables
Dim Cnxn As ADODB.Connection
Dim strCnxn As String
' Open connection
Set Cnxn = New ADODB.Connection
strCnxn = CurrentProject.AccessConnection
Cnxn.Open strCnxn
' Open command object with one parameter
Set pCurDb = New ADODB.Command
Set pCurDb.ActiveConnection = Cnxn
End If
Set CurDb = pCurDb
End Function
i know that this code CurrentProject.AccessConnection is calling the connection
my Questions is where is that configured ? where do i change it ?
Edit / Delete