Go Premium for a chance to win a PS4. Enter to Win

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

Permissions problem

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
castello
Asked:
castello
1 Solution
 
hongjunCommented:
Make sure the mdb file is not opened. Close it. Also make sure IUSR_COMPUTERNAME has permission on the mdb file.

hongjun
0
 
Richie_SimonettiCommented:
Also, take note that you not have this file open it in design mode in other session.
0
 
clanglCommented:
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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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