Hello All,

I got some serious problem here. I am pretty sure you all able to find the solution of it. I am not able to insert record in microsoft access 2003 database. I have already given permission to database through inetmgr.

Error

System.Data.OleDb.OleDbException: The Microsoft Jet database engine cannot open the file C:\Inetpub\wwwroot\JustTest\Database\db1.mdb'. It is already opened exclusively by another user, or you need permission to view its data. at System.Data.OleDb.OleDbConnection.ProcessResults(I nt32 hr) at System.Data.OleDb.OleDbConnection.InitializeProvid er() at System.Data.OleDb.OleDbConnection.Open() at JustTest.GridUpdate.Button1_Click(Object sender, EventArgs e) in c:\inetpub\wwwroot\justtest\gridupdate.aspx.cs:lin e 75


i am using windows xp professional service pack 2, visual studio .net 2003


Abdul Ghaffar

Hi there,

Check out this FAQ: http://Imar.Spaanjaars.Com/QuickDocId.aspx?QUICKDOC=263

HtH,

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

Thats Brillient My Friend......

It Worked.....Actually my pcs file system was NTFS, I haven't faced this type of problem while i was using FAT32.

Thanks Once Again......becasue for the last two days i was busy finding out any solution on net.

Abdul Ghaffar

FAT32 doesn't enforce security, so you'll never run into this.

However, as you found out, NTFS does.....

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