Hi hi again Guys...

Now, I'm confuse about opening connection and recordset.
I have a database in Access, named "MyWebDb.Mdb" and the password to open it is "Will"

I'm trying several ways... Here they are :

1st way : From Mark Sreeves
Conn.Open("DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("\MyWebDB.mdb"))
The question for this is : How should I put the Password ???


2nd way : Using Microsoft Jet OLEDB 4.0
Conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & strDBPath & ";Password=Will;"

The question is :
My open statement above doesn't work out.

The error occured is :
Microsoft JET Database Engine error '80040e4d'

Cannot start your application. The workgroup information file is missing or opened exclusively by another user.

/Login.asp, line 19

But, if I eliminate the password at myWebDB.Mdb, and remove the password at Conn.Open statement, like below :

Conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & strDBPath & ";"

My ASP page will start / run.

The question is why ???


And how can I open it, if I want to use password on my Database ???

BRgds,
Wen Lie

[Edited by Wen Lie on 05-27-2000 at 12:49 AM]