hi,
im using VB.net to create an invoice application and im using crystal report viewer to view the preview of the reports being printed.
im using this program on one computer and i don't want the user to open the database. but it will allow them to add in datas via the program.
the database im using is Microsoft Access 2003 and e file's extension is .mdb
i have problem with the security.
1) if i secure the database by using SET DATABASE password,
how do i insert that password into the VB.net 2005 coding when opening the crystal report viewer? i tried using. crystaldecisions.crystalreports.tablelogoninfo.connectioninfo.password = "password"
it doesn't work.
it will keep asking me to insert the password all over again and the report wun be loaded.
2) if supposingly i use the workgroup to secure the database,
how do i attach the .mdw file in the crystal report viewer codings?
3) if there's a better way to lock the database from being opened but allowing it to be manipulated (add/edit) via the program i created using VB.net 2005. how?
btw. i can consider myself a beginner in vb.net
please dun hesitate to guide me through. thanks and sorry.
thanks for the help in advance.
richard
NB: I have created a copy of this in crystal reports section.
not very sure in which section does this thing fall under.
sorry.
im using VB.net to create an invoice application and im using crystal report viewer to view the preview of the reports being printed.
im using this program on one computer and i don't want the user to open the database. but it will allow them to add in datas via the program.
the database im using is Microsoft Access 2003 and e file's extension is .mdb
i have problem with the security.
1) if i secure the database by using SET DATABASE password,
how do i insert that password into the VB.net 2005 coding when opening the crystal report viewer? i tried using. crystaldecisions.crystalreports.tablelogoninfo.connectioninfo.password = "password"
it doesn't work.
it will keep asking me to insert the password all over again and the report wun be loaded.
2) if supposingly i use the workgroup to secure the database,
how do i attach the .mdw file in the crystal report viewer codings?
3) if there's a better way to lock the database from being opened but allowing it to be manipulated (add/edit) via the program i created using VB.net 2005. how?
btw. i can consider myself a beginner in vb.net
please dun hesitate to guide me through. thanks and sorry.
thanks for the help in advance.
richard
NB: I have created a copy of this in crystal reports section.
not very sure in which section does this thing fall under.
sorry.