Hi.


What is the correct connection string, for Msaccess Databases in Ado.Net?

The Databases have Password, and locate in my PC.

Thanks for all

Imports System.Data.OleDb
....
Dim oOleDbConnection As OleDbConnection
Dim sConnString As String = _
"Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=C:\myPath\myJet.mdb;" & _
"User ID=Admin;" & _
"Password="
oOleDbConnection = New OleDb.OleDbConnection(sConnString)
oOleDbConnection.Open()

Take a look at Carl Prothman's site; "World's largest collection of ADO and
ADO.NET connection strings on the internet!":
http://www.carlprothman.net/Default.aspx?tabid=81

HTH,
-B

"dtto086" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi.
>
>
> What is the correct connection string, for Msaccess Databases in Ado.Net?
>
> The Databases have Password, and locate in my PC.
>
> Thanks for all
>
>

Thanks for all

andres
"Beth Massi [Architect MVP]" <(E-Mail Removed)> escribió en el mensaje
news:(E-Mail Removed)...
> Imports System.Data.OleDb
> ...
> Dim oOleDbConnection As OleDbConnection
> Dim sConnString As String = _
> "Provider=Microsoft.Jet.OLEDB.4.0;" & _
> "Data Source=C:\myPath\myJet.mdb;" & _
> "User ID=Admin;" & _
> "Password="
> oOleDbConnection = New OleDb.OleDbConnection(sConnString)
> oOleDbConnection.Open()
>
> Take a look at Carl Prothman's site; "World's largest collection of ADO
> and ADO.NET connection strings on the internet!":
> http://www.carlprothman.net/Default.aspx?tabid=81
>
> HTH,
> -B
>
> "dtto086" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> Hi.
>>
>>
>> What is the correct connection string, for Msaccess Databases in Ado.Net?
>>
>> The Databases have Password, and locate in my PC.
>>
>> Thanks for all
>>
>>
>
>