Connect to secure Access session

[ahhuang]

I am using Assess db with vb.
my db is secured with a password
My coding is as below:

dim crxreport as new crystalreport1
dim crxtable as craxdt.database
for each crxtable in crxreport.database.tables
crxtable.setsessioninfo "","password"
next

my problem is eventhough i have include "setsessioninfo", the password prompt still appears when running d report preview. how do i do to make it not appearing

 

[pgtek]

hi
declare your password as a variable and set it there and your database also

pg