hi

I want to connect to Access database which is password protected, through ASP.Net

Can u please tell me connection string for passing password?

Thanks,
Swati

snshah

Hi,

' without the password
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\inetpub\wwwroot\articleexamples\pubs.mdb

' with the password
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\inetpub\wwwroot\articleexamples\pubs.mdb ; Persist Security Info=False;Jet OLEDB:Database Password=hack

Cheers,

  nalla

Nalla,
Thank for your reply to this thread. I had subscribed to it with a lot of interest. This was helpful in finding some of the problems that I was having, as well, but the I continue to have a permissions problem because I don't have just a database password but I have implemented access security with user id's and user passwords. I have tried various permutations of your connection string to try to get the User name and password to pass to Jet but with no success. I have relieved the 'Cannot find valid ISAM' error by switching the systemdb in the access registry to the .mdw file used by the target .mdb file but now get the 'You do not have required permissions' error.

Any help is greatly appreciated.
Thanks again,
Dave

David B. Morgan

Hi Dave,
   Did you use ADO data control to get the connection string? if not use ADO data control to create the connnection string without creating manually. assign user id, password in the ADO data control, test connection, copy the connection string from the ADO data control to your vb code editor.

  If your problem has not resolved please post the error number, tell how did you assigh the user id and password to your access database.



nalaka hewage