In an aspx page I have a datagrid populated by an oledbDataAdaptor and
dataset from a Microsoft Access database.
When the line <identity impersonate="true" /> is placed in the web.config ,
I am able to populate and view the datagrid. I am also able to add a new
record to the datagrid by using:
this.dateSett11.Table1.Rows.InsertAt(dr, 9999999);
DataAdaptDA.Update(dateSett11);
When I remove the line <identity impersonate="true" /> from web.config , I
can populate and view the datagrid but when I try to add a record, I get the
error:
The Microsoft Jet database engine cannot open the file
'C:\Inetpub\wwwroot\testo\DatsDB.mdb'. It is already opened exclusively by
another user, or you need permission to view its data.
This posting may show my limited understanding of permissions,
never-the-less I would like to find out what I must do to be able to write
to the dataset without using impersonation. Where do I set or change the
premissions ?
Thanks in advance for your help,
Jim