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?:
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: