ado connections

[Jason]

Hi,

Where should i place the following ado-connection info if i want to call it
from every form i create.
For testing purposes i used the code in the form's module and it worked.

Here is the code:

Dim cnn As ADODB.Connection

Set cnn = New ADODB.Connection

With cnn
.Provider = "sqloledb"
.Properties("Data Source") = "local"
.Properties("Initial Catalog") = "NEW"
.Properties("User ID") = "sa"
.Properties("Password") = "password"
End With

 

[RSusanto]

You can create public procedure and put it in the modules area.

 

[Jason]

Can you tell me how the syntax is?

You can create public procedure and put it in the modules area.

 

[Jason]

Hi,

I did what you suggested. But how can i call it from another form if i want
to use the current connection? Is this also the way to use connection
pooling or am i confused?

Thnx

 

[RSusanto]

I just realize if you use the SQL server, you can connect to the database
using ADP project in Access.
So you dont have to use this connection string anymore.
you just need 1 statement:

put it at the general modules
dim cn as new adodb.connection

public sub Set_Cn
set cn = currentproject.connection
end sub

then call it whenever you need it.