Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 317
  • Last Modified:

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





0
alberte
Asked:
alberte
1 Solution
 
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.

Join & Write a Comment

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now