Connecting to Acess DB

Jerome Brown

Member
Joined
Oct 21, 2004
Messages
8
Programming Experience
Beginner
Hello,
I am developing my first web application and I am using Acess on the backend. When I was trying to access the dataset, I received the following error.


Server Error in '/WebApplication1' Application.

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

[font=Arial, Helvetica, Geneva, SunSans-Regular, sans-serif]Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.OleDb.OleDbException: The Microsoft Jet database engine cannot open the file 'C:\Inetpub\wwwroot\WebApplication1\bin\jointdb.mdb'. It is already opened exclusively by another user, or you need permission to view its data.

Thanks in advance.[/font]
 

JuggaloBrotha

VB.NET Forum Moderator
Staff member
Joined
Jun 3, 2004
Messages
4,524
Location
Lansing, MI; USA
Programming Experience
10+
i get that error if i have the DB opened in Access as i'm haveing VB access the DB, all ya gotta do in that case is close MS-Access and windows unlocks the DB for VB
 

Jerome Brown

Member
Joined
Oct 21, 2004
Messages
8
Programming Experience
Beginner
DB is closed.

I have the DB closed. I do have multiple copies of the db file. Could that be a problem?
 

TPM

Well-known member
Joined
Dec 7, 2004
Messages
623
Location
CA
Programming Experience
3-5
It's not that it's open, it's that the ASP.Net user doesn't have permission to open it. Right Click on you DB and goto permissions and add the asp.net user.

TPM
 

jetster

New member
Joined
Jan 26, 2005
Messages
4
Programming Experience
Beginner
I right clicked on my Access 2000 databases and does not give that as option.

Can check box "hidden" "read" or "archive" archive is checked on mine
 

TPM

Well-known member
Joined
Dec 7, 2004
Messages
623
Location
CA
Programming Experience
3-5
when you right click yoou should get a menu with:properties (click on it)
then goto the securrity tab and click on Add - add the asp user and set the permissions.
 

jetster

New member
Joined
Jan 26, 2005
Messages
4
Programming Experience
Beginner
security tab adjustment

I have Access 2000 and there is no security tab or any other tabs to click on??

I am right clicking on the database file icon itself, correct?
 

TPM

Well-known member
Joined
Dec 7, 2004
Messages
623
Location
CA
Programming Experience
3-5
Yes the .MDB file. Do you have admin rights?
 
Top Bottom