Solved

Permissions problem

Posted on 2002-04-14
3
121 Views
Last Modified: 2010-05-02
I am attemptimg to do a web app for the first time & need to get data from an access db.  Actually, I wanted to use mySQL, but our buddy Bill won't let the ODBC work with the standard edition.

On NT2000 I get this error:

The Microsoft Jet database engine cannot open the file 'D:\Inetpub\wwwroot\WebApplication1\Restaurant.mdb'. It is already opened exclusively by another user, or you need permission to view its data.

What do I need to set?
0
Comment
Question by:castello
[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
3 Comments
 
LVL 33

Accepted Solution

by:
hongjun earned 50 total points
ID: 6939747
Make sure the mdb file is not opened. Close it. Also make sure IUSR_COMPUTERNAME has permission on the mdb file.

hongjun
0
 
LVL 16

Expert Comment

by:Richie_Simonetti
ID: 6940563
Also, take note that you not have this file open it in design mode in other session.
0
 

Expert Comment

by:clangl
ID: 6940928
THis error usually occurs when you have security set up with in the access database and the *.mdw is not refernced to the correct location in the connection string.  In this case you need to refernce the mdw database in your connection string:

"Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;Data Source=" & strLocFilDB & ";Jet OLEDB:System database=" & strlocSystemDB & ";User ID= '" & strUsr & "';Password='" & strPwd & "'"
strLocFilDB is the location of the actual database
strlocSystemDB is the location of the MDW database

Hope this helps
0

Featured Post

Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

Question has a verified solution.

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

I’ve seen a number of people looking for examples of how to access web services from VB6.  I’ve been using a test harness I built in VB6 (using many resources I found online) that I use for small projects to work out how to communicate with web serv…
This article describes some techniques which will make your VBA or Visual Basic Classic code easier to understand and maintain, whether by you, your replacement, or another Experts-Exchange expert.
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

734 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