Need Help to find SQL connections string

[datadc]

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 ?

[RuralGuy]

Cross Posted at: https://access-programmers.co.uk/for...d.php?t=291521

When you cross post, please tell readers you have done so and provide the associated link(s).

Here is why!

[datadc]

Cross Posted at: https://access-programmers.co.uk/for...d.php?t=291521

When you cross post, please tell readers you have done so and provide the associated link(s).

Here is why!

i am really sorry about this,


i figured one for the UK and one for the USA, but you are %100 right i apologist

[pbaldy]

That connects to the current database. To connect to something else, you'd set the string variable to the appropriate string. What are you trying to connect to?

[datadc]

i finally figured it out
the guy used an access project file to configure the connections