ADP Project (1 Viewer)

[antonio.manoj.derose]

Hi All,

I have given an ACCESS ADP Project, which gets committed in SQL Server tables.

However, I don't see the connection string nor a provider in the code.

But, when I run the code putting a debug point, and open the immediate window I add the '?CurrentProject.Connection.ConnectionString' and I get the result as

Provider=Microsoft.Access.OLEDB.10.0;Persist Security Info=True;Data Source=wsdb;User ID=sa;Password=password;Initial Catalog=KAIIOWAS;Data Provider=SQLOLEDB.1

But where it had set in the coding, I only can see the below

Sub nilSetConnection(con As ADODB.Connection)
Set con = New ADODB.Connection
con.connectionString = CurrentProject.Connection
con.Open
End Sub

Thanks,

Antonio