₦airaland Forum

Please can anyone help me on how to connect visual basic 2008 with a password protected access 2007 or 2010.Each time i run my program its always telling me "not a vaild password".I have tried all i can,infact search online for solutions but am still getting the same error.Thanks

I don't think you have any problems with ur ConnectionString. The bug is the file u are connecting to (the protected Access file). The logic is: when u want to open the file outside ur application, u would normally supply a password. Now u did nt make any provition for that on ur application. I'm nt Advanced in VB.net, but my solution is: disable the password from the Access file. There may b other route to this witout disabling the password but i think u would be fine doing so. I am goin 2 try my hand on it and wil keep u posted if i hav any breakthrough witout disabling the password. Cheers!

Tamorion: I don't think you have any problems with ur ConnectionString. The bug is the file u are connecting to (the protected Access file). The logic is: when u want to open the file outside ur application, u would normally supply a password. Now u did nt make any provition for that on ur application. I'm nt Advanced in VB.net, but my solution is: disable the password from the Access file. There may b other route to this witout disabling the password but i think u would be fine doing so. I am goin 2 try my hand on it and wil keep u posted if i hav any breakthrough witout disabling the password. Cheers!

thanks i'll appreciate it if u can help