[AccessD] Access ADP - Setting connection

Hi group,

I've got an ADP. In File Connection I've set a
connection to a SQL Server 2000 database.

I want (Read: DBA wants...) to create an ini file
which is in a secure location where the connection
info resides.

Is this possible?

I've created an AutoExec macro that executes a
function Main. This function reads an ini file and
creates a new connection:

Dim cnn As ADODB.Connection
Set cnn = New ADODB.Connection

With cnn
      .Provider = "SQLOLEDB"
      .Properties("Data Source") = "xxxx\yyy01"
      .Properties("Initial Catalog") = "APP"
      .Properties("User Id") = "xxxx"
      .Properties("Password") = "yyyyy"
      .Properties("Persist Security Info") = False
      .Open
End With 

After this I excpect a list of tables that reside in
this database...however I do not see them.

I'm doing something wrong? Did I miss something?

TIA
Sander


 
____________________________________________________________________________________
Expecting? Get great news right away with email Auto-Check. 
Try the Yahoo! Mail Beta.
http://advision.webevents.yahoo.com/mailbeta/newmail_tools.html