ADO

[Irfan]

What is the connectionstring to access MS ACCESS 97 database through ADO if
databse is protected with password.

[poloart]

Here is an Example:

strConnectionString = "Provider=Microsoft.Jet.OLEDB.3.51;" & _
"Persist Security Info=False;" & _
"Data Source = " & strDataBase & _
"User ID = " & strUserId & _
"Password = " & strPassword

or you can Open the Database like this:

strConnectionString = "Provider=Microsoft.Jet.OLEDB.3.51;" & _
"Persist Security Info=False;" & _
"Data Source = " & strDataBase

cnnConection.open strConnectionString, strUser, strPassword

i will use the second.

"Irfan" <s_irfanuddin@usa.net> wrote:
>
>What is the connectionstring to access MS ACCESS 97 database through ADO
if
>databse is protected with password.
>
>

[Andrew Grillage]

Don't forget that you must specify the Workgroup Information File also. An
example is given here
http://www.able-consulting.com/ADO_C...orMicrosoftJet

--
Andrew Grillage
http://vbdata.iwarp.com


"poloart" <poloart@hotmail.com> wrote in message
news:38ef81dc$1@news.devx.com...
>
> Here is an Example:
>
> strConnectionString = "Provider=Microsoft.Jet.OLEDB.3.51;" & _
> "Persist Security Info=False;" & _
> "Data Source = " & strDataBase & _
> "User ID = " & strUserId & _
> "Password = " & strPassword
>
> or you can Open the Database like this:
>
> strConnectionString = "Provider=Microsoft.Jet.OLEDB.3.51;" & _
> "Persist Security Info=False;" & _
> "Data Source = " & strDataBase
>
> cnnConection.open strConnectionString, strUser, strPassword
>
> i will use the second.
>
> "Irfan" <s_irfanuddin@usa.net> wrote:
> >
> >What is the connectionstring to access MS ACCESS 97 database through ADO
> if
> >databse is protected with password.
> >
> >
>