Hello

I am using Visual studio. net application to create my asp file.


These are the errors i am constantly getting!!!

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

Line 194: Private Sub Page_Load(ByVal sender As System.Object,

ByVal e As System.EventArgs) Handles MyBase.Load

Line 196: OleDbDataAdapter1.Fill(DataSet1)this line is highlighted by my debugger

Line 197: DataGrid1.DataSource = DataSet1
Line 198: DataGrid1.DataBind()
I used the wizard to create my connection and set my sql statement!


When i open my server explore it tells me that i am connected
to the database and from the server explore i can edit and save any changes that i have made.
I was wondering do i have to have mdb file in a particular folder?
Example like the bin or root directory.

I don't have access so i just download the mdb file from wroxs.
Whats curious is i am able to make a connection when i just use a text editor like notepad.

Hi there,

I think this is a classic ASP forum, so you may try your luck in one of the .NET forums for similar problems in the future.

Anyway, the problem is related to permissions. When you connect to the database using the Server Explorer (I assume you're using Visual Studio .NET?) you connect under your user account which apparently has enough permissions.

At run-time, however, the web server connects to this database. The account that the web server uses is usually IUSR_MachineName where MachineName is the name of your computer. This account needs enough permissions for both the .mdb file and the folder it resides in.

To change the permissions, open a Windows Explorer, right-click C:\database, choose Properties and then on the Security tab add the IUSR_MachineName account. Make sure it has at least read and change permissions.

HtH,

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

Hi!
I also had this problem when using Dreamweaver MX, and as you say, no bother with Notepad editting & viewing in a browser, or on a remote platform.
I'm not too hot on the .Net stuff yet but certain wysiwyg environments keep hold of the connection they create whilst setting up the initial environment and whilst working with it ( if that makes sense)

Try looking in your folder where you're storing your .mdb file, if there's also a .ldb file with the same prefix, right click and send to notepad, you'll probably see that the database is opened by admin..
Save your work, close the software environment down and delete the .ldb file then try again...
Might work
:)

Simon

Don't think, do!