how to access password protected database?

[Sean]

Hi experts,

I have a quick question for you.

I have a program, written in VB6, that uses a Data object to access a Microsoft
Access database. The database has recently had a password put onto it.
Now, instead of just access the database though the Data object, I need to
input this password so that the program can use the database. But, I'm not
100% sure on the how.

I'd appreciate any help in this matter.

Sean

[Michael Culley]

Just put Password=MyPassword in the connection string.

--
Michael Culley
www.vbdotcom.com

[Paul Clement]

On 17 Jul 2002 17:40:26 -0700, "Sean" <win2k2b@aol.com> wrote:

¤
¤ Hi experts,
¤
¤ I have a quick question for you.
¤
¤ I have a program, written in VB6, that uses a Data object to access a Microsoft
¤ Access database. The database has recently had a password put onto it.
¤ Now, instead of just access the database though the Data object, I need to
¤ input this password so that the program can use the database. But, I'm not
¤ 100% sure on the how.
¤
¤ I'd appreciate any help in this matter.
¤

I don't know whether you are using ADO, DAO or one of the DataControls but the following refers to
ADO:

http://support.microsoft.com/default...;EN-US;q191754


Paul ~~~ pclement@ameritech.net
Microsoft MVP (Visual Basic)

[Sean]

>I don't know whether you are using ADO, DAO or one of the DataControls but
the following
>refers to
>ADO:
>
>http://support.microsoft.com/default...;EN-US;q191754
>
>
>Paul ~~~ pclement@ameritech.net
>Microsoft MVP (Visual Basic)

Ah, thank you very much, that did the trick.
Sean

[ralph]

"Michael Culley" <mculley@optushome.com.au> wrote:
>Just put Password=MyPassword in the connection string.
>
>--
>Michael Culley
>www.vbdotcom.com
>
>

In the same vein, is there any cute work-arounds for handling "pass-thru"
or linked tables from another database (as400, oracle). That is without skipping
access and opening the table with a separate connection.

[Ronny]

i know how to put password=mypassword, (using ado)

but if the case is, i used adodc ? how ????

"ralph" <nt_consulting32@hotmail.com> wrote:
>
>"Michael Culley" <mculley@optushome.com.au> wrote:
>>Just put Password=MyPassword in the connection string.
>>
>>--
>>Michael Culley
>>www.vbdotcom.com
>>
>>
>
>In the same vein, is there any cute work-arounds for handling "pass-thru"
>or linked tables from another database (as400, oracle). That is without
skipping
>access and opening the table with a separate connection.

[Michael Culley]

The adodc has a connection string, just add it to that.

--
Michael Culley
www.vbdotcom.com


"Ronny" <ronnyweb2000@yahoo.com> wrote in message
news:3d3d0616$1@10.1.10.29...
>
> i know how to put password=mypassword, (using ado)
>
> but if the case is, i used adodc ? how ????
>
> "ralph" <nt_consulting32@hotmail.com> wrote:
> >
> >"Michael Culley" <mculley@optushome.com.au> wrote:
> >>Just put Password=MyPassword in the connection string.
> >>
> >>--
> >>Michael Culley
> >>www.vbdotcom.com
> >>
> >>
> >
> >In the same vein, is there any cute work-arounds for handling "pass-thru"
> >or linked tables from another database (as400, oracle). That is without
> skipping
> >access and opening the table with a separate connection.
>