469,628 Members | 1,214 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,628 developers. It's quick & easy.

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!
Nov 13 '05 #1
2 4214
On Tue, 04 Oct 2005 02:41:47 GMT, "Jozef" <me@you.com> wrote:

Connectionstrings are all here:
www.connectionstrings.com/

-Tom.

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!


Nov 13 '05 #2
Thanks Tom, I had already run the gammut of connection strings which all
gave me the same error.

"Tom van Stiphout" <no*************@cox.net> wrote in message
news:8l********************************@4ax.com...
On Tue, 04 Oct 2005 02:41:47 GMT, "Jozef" <me@you.com> wrote:

Connectionstrings are all here:
www.connectionstrings.com/

-Tom.

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!

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by Scott A. Jones | last post: by
1 post views Thread by robert demo via AccessMonster.com | last post: by
16 posts views Thread by Jozef | last post: by
4 posts views Thread by =?Utf-8?B?Ym9va2VyQG1ndA==?= | last post: by
6 posts views Thread by zaina | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.