Solved

Access DB connection string

Posted on 2008-10-07
2
296 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
2 Comments
 
LVL 84

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

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Question has a verified solution.

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

I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
On July 14th 2015, Windows Server 2003 will become End of Support, leaving hundreds of thousands of servers around the world that still run this 12 year old operating system vulnerable and potentially out of compliance in many organisations around t…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

863 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now