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?
castelloAsked:
Who is Participating?
 
hongjunConnect With a Mentor Commented:
Make sure the mdb file is not opened. Close it. Also make sure IUSR_COMPUTERNAME has permission on the mdb file.

hongjun
0
 
Richie_SimonettiIT OperationsCommented:
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
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.

All Courses

From novice to tech pro — start learning today.