Connect automatically using ADODB connection

[winstz]

Hi all,

I made several programs using Macro Excel (VBA) and Crystal Report to print out reports that accpac can not handle.

First, I login to ACCPAC using my user id and password.

Then i attach a report that i create by using crystal report to accpac browser.
If i open the report then it will show the result instantly (without login to database because the crystal report can use the user id, password, and database that i have entered the first time in accpac)

Then i attach a Macro Excel (VBA) to accpac browser.
If i open the Macro Excel (VBA) then the macro will ask for user id, password and database that i want to connect (using adodb connection).

Does anyone have trick how the Macro Excel (VBA) can use the user id, password, and database that i have entered the first time in accpac (like Crystal report) ??? so that i don't have to enter it again.

Need assistance please.

Thanks

 

[Jay Converse]

Use a DSN with AD authentication.

 

[winstz]

Ok. Thanks for the answer.