Need help with connection string in OpenDatabase

Hello,

I have a database that I have passworded. When I try to use OpenDatabase
with the Connect parameter filled in, I keep getting "Not a valid password",
even if I use the actual connect string from one of the tables. I have no
other security on the database, just a single password.

This is what I have;

'----Start Code ----
Dim db as database
Dim dWs as workspace

Set dWs= CreateWorkspace("", "Admin", "")
Set db = dWs.OpenDatabase(strPathFile, , , "MS Access;pwd=MyPassword")
'----End Code ----

Any ideas what's up?

Thanks!

On Tue, 04 Oct 2005 02:41:47 GMT, "Jozef" <me@you.com> wrote:

Connectionstrings are all here:
www.connectionstrings.com/

-Tom.

[color=blue]
>Hello,
>
>I have a database that I have passworded. When I try to use OpenDatabase
>with the Connect parameter filled in, I keep getting "Not a valid password",
>even if I use the actual connect string from one of the tables. I have no
>other security on the database, just a single password.
>
>This is what I have;
>
>'----Start Code ----
>Dim db as database
>Dim dWs as workspace
>
> Set dWs= CreateWorkspace("", "Admin", "")
>Set db = dWs.OpenDatabase(strPathFile, , , "MS Access;pwd=MyPassword")
>'----End Code ----
>
>Any ideas what's up?
>
>Thanks!
>[/color]

Thanks Tom, I had already run the gammut of connection strings which all
gave me the same error.

"Tom van Stiphout" <no.spam.tom7744@cox.net> wrote in message
news:8lt3k1tnjbeuij84314f9blgbtcigqdogj@4ax.com...[color=blue]
> On Tue, 04 Oct 2005 02:41:47 GMT, "Jozef" <me@you.com> wrote:
>
> Connectionstrings are all here:
> www.connectionstrings.com/
>
> -Tom.
>
>[color=green]
>>Hello,
>>
>>I have a database that I have passworded. When I try to use OpenDatabase
>>with the Connect parameter filled in, I keep getting "Not a valid
>>password",
>>even if I use the actual connect string from one of the tables. I have no
>>other security on the database, just a single password.
>>
>>This is what I have;
>>
>>'----Start Code ----
>>Dim db as database
>>Dim dWs as workspace
>>
>> Set dWs= CreateWorkspace("", "Admin", "")
>>Set db = dWs.OpenDatabase(strPathFile, , , "MS Access;pwd=MyPassword")
>>'----End Code ----
>>
>>Any ideas what's up?
>>
>>Thanks!
>>[/color]
>[/color]