Microsoft Access
--
Questions
--
Followers
Top Experts
Access DB connection string
Hi,
I have a working connection to my access DB Mydb.mdb (access 2003) as shown
<%
connStr = "Provider=Microsoft.Jet.OL EDB.4.0; Data Source=" & Server.MapPath("../_databa se/Mydb.md b")
%>
I used security option to put in a password on the DB and changed the string to
connStr = "Provider=Microsoft.Jet.OL EDB.4.0;Da ta Source=" & _
Server.MapPath("../_databa se/Mydb.md b") & ";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
I have a working connection to my access DB Mydb.mdb (access 2003) as shown
<%
connStr = "Provider=Microsoft.Jet.OL
%>
I used security option to put in a password on the DB and changed the string to
connStr = "Provider=Microsoft.Jet.OL
Server.MapPath("../_databa
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
Zero AI Policy
We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.
ASKER CERTIFIED SOLUTION
membership
Log in or create a free account to see answer.
Signing up is free and takes 30 seconds. No credit card required.
I used
connStr = "Provider=Microsoft.Jet.OL EDB.4.0;Da ta Source=C:\...\Mydb_db.mdb; Jet OLEDB:Database Password=MyPass;"
Works
connStr = "Provider=Microsoft.Jet.OL
Works






EARN REWARDS FOR ASKING, ANSWERING, AND MORE.
Earn free swag for participating on the platform.
Microsoft Access
--
Questions
--
Followers
Top Experts
Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.