hello everybody
this problem is bothering me for last two days,i have an application in VB
with a password secured access database, in my Visual Basic application i
have added a form and am viewing crystal report... i made connection and
added fields to report but when i run it logon fails.. i have simply added
connection via wizard and have given pass word there...but when i opens the
report via Visual basic application it fails to open..i am using microsoft access as database
also i tried giving connection string : to my form load but still giving
error:
string is:
REPORT.DATABASE.LOGONSERVEREx "p2sOLEDB.DLL","PROJ.MDB
;"","","","OLEDB","PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA
SOURCE=PROJ.MDB;PERSIST
SECURITY INFO=FALSE;JET OLEDBATABASE PASSWORD=PASSWRD"
IT GIVES DAO ERROR CODE 0XBD7
SOURCE = DAO WORKSPACE
DESCRIPTION : NOT A VALID PASSWORD..
I CHNGED CONNECTION TO ODBC AND CHANGED OLEDB ABOVE TO ODBC BUT THEN IT
GIVES ERROR SAYING ERROR IN PROVIDER IF I RUN ONLY A CRYSTAL REPORT MADE IN
CRYSTAL REPORTS 9 WITHOUT USING VISUAL BASIC IT RUNS WELL ONLY WHEN I RUN IT
FROM VB IT GIVES ERROR... PLZ HELP
AM REALLY STUCK