Instead of just the phrase Password, try using Database Password as I think
that's the more correct versoin for the JET driver.
Sometimes after opening an Access application it will stay locked for a
while. Look to see if there is a lock file with the same name as the
database in the directory. If so, try deleting the lock file and see if that
helps. Have you also tried rebooting in case the OS has a lock on it? I used
to have similar problems when I worked with Access and classic ASP and what
I ended up doing occasionally is creating a brand new Access mdb and dumping
the contents from the original into it to break the lock. It's a worste case
fix, but sometimes Access just gets something stuck in its mind and you
can't get around it.
--
Hope this helps,
Mark Fitzpatrick
Former Microsoft FrontPage MVP 199?-2006
"bob" <sdvsé@sds.dfgwrote in message
news:eZ*************@TK2MSFTNGP06.phx.gbl...
Hi,
I use a Access database for my asp.net application.
I use this connection string:
sConnectionString = "Provider = Microsoft.Jet.OLEDB.4.0; Data Source =
c:\mydb.mdb"
Now i put a pasword to the Access database and i changed the connection
string to:
sConnectionString = "Provider = Microsoft.Jet.OLEDB.4.0; Data Source =
c:\mydb.mdb; Password=mypassw"
But then i get the error:
"Can't start application. The file is missing or is open in exclusive mode
by another user"
I opened the first time the file in exclusive mode in order to put the
password, but then i reopened it without exclusive mode.
Any idea how to solve this?
Thanks
Bob