I work with Access mdb, VS 2005 and now I'm connected through ODBC.
As I see it, that's not good(since it's impossible to drag a table from the database to Form for assign to Connection and DataAdapter objects or maybe not??)
So I go "Add connections" and then take "MS Access DB file", enter Connection string as:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents and Settings\My Documents\Mail.mdb" , test the connection successfully, but on closing i got error:
" Format of the initialization string does not confirm to specification starting at index 0"