Access DB connection string

Hi,
I have a working connection to my access DB Mydb.mdb (access 2003) as shown
<%
connStr = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("../_database/Mydb.mdb")
%>

I used security option to put in a password on the DB and changed the string to
connStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _
Server.MapPath("../_database/Mydb.mdb") & ";Password=MyPassword;"

Now I get the following error

Microsoft JET Database Engine error '80040e4d'
Cannot start your application.
The workgroup information file is missing or opened exclusively by another user.

I sure this is the correct password and need help fixing the problem.
Thanks





alberteAsked:
Who is Participating?
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
You need to include the path to the Workgroup file ... include "SystemDB=Server.MapPath("SomePathHere"):

connStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _
Server.MapPath("../_database/Mydb.mdb") & ";SystemDB=Server.MapPath("SomePathHere");Password=MyPassword;"

You might need to consult with your ISP to determine exacty where your workgroup file is located, or (if you can) you can simply upload your "system.mdw" file to a location on your server and point the SystemDB variable to there.
0
 
alberteAuthor Commented:
I used
connStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\...\Mydb_db.mdb;Jet OLEDB:Database Password=MyPass;"

Works
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.