Passing in Passwords as Parameters

the_utmost

Registered User.
Local time
Today, 15:16
Joined
Mar 10, 2005
Messages
40
Hi:

I have to open a database that needs a user name and a password. We have a generic one that I can use but I don't know how to pass that information into Access as I remotely open the second database. Here is my code to open the db that needs the password:

Dim Acc As Access.Application

Set Acc = CreateObject("access.application")
Acc.OpenCurrentDatabase (strPath)
Acc.DoCmd.OpenReport rsRunningReports!report_name, acViewNormal, , strWhereSQL
Acc.DoCmd.Quit

When I use DAO it does not give me many options. Should I change to ADO?:
 
Last edited:

Users who are viewing this thread

Back
Top Bottom