Not a valid password

[iyappan]

I'm trying to read and Write the datagridview using .accdb files through oledb connection . when i Run the application it Showing error like " Not a valid password " .i check the database test connection in the connection properties..That also shows "Test Connection succeeded ",then why the error is coming ???

my connectString is[TABLE]
[TR]
[TD="class: number"]
[/TD]
[TD="class: content"] [/TD]
[/TR]
[/TABLE]

[TABLE]
[TR]
[TD="class: number"]
[/TD]
[TD="class: content"]   Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccessFile.accdb;[/TD]
[/TR]
[/TABLE]

[TABLE]
[TR]
[TD="class: number"]
[/TD]
[TD="class: content"]Persist Security Info=False;[/TD]
[/TR]
[/TABLE]

 

[JuggaloBrotha]

Sounds like you need to be using a connection string that sends a password to the database:

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccessFile.accdb;Jet OLEDB:Database Password=YourDBPasswordHere;

Just replace "C:\myFolder\myAccessFile.accdb" with your database file location and "YourDBPasswordHere" with the password for the database.