Solved

Access DB connection string

Posted on 2008-10-07
2
307 Views
Last Modified: 2010-04-21
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





0
Comment
Question by:alberte
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 85

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 250 total points
ID: 22660864
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
 

Author Closing Comment

by:alberte
ID: 31503893
I used
connStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\...\Mydb_db.mdb;Jet OLEDB:Database Password=MyPass;"

Works
0

Featured Post

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
This article provides a convenient collection of links to Microsoft provided Security Patches for operating systems that have reached their End of Life support cycle. Included operating systems covered by this article are Windows XP,  Windows Server…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question