Weird problems with Update Query

  • Thread starter Thread starter VB Programmer
  • Start date Start date
V

VB Programmer

I am trying to run an update query against my Access database. It kept
telling me that it must be an "updateable query". I did research and I
found out that I have to give ASPNET account r/w access to the file/dir. I
did that (full control). But, now I get this error when I try to fill a
dataset:

System.Data.OleDb.OleDbException: Could not use ''; file already in use. at
System.Data.OleDb.OleDbConnection.ProcessResults(Int32 hr) at
System.Data.OleDb.OleDbConnection.InitializeProvider() at
System.Data.OleDb.OleDbConnection.Open() at
System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection,
ConnectionState& originalState) at
System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32
startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet
dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand
command, CommandBehavior behavior) at
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at
ExecuCare.AdminSubscriberManagement.Page_Load(Object sender, EventArgs e) in
c:\inetpub\wwwroot\ExecuCare\Secured\AdminCustomerManagement.aspx.vb:line
217

If I remove my explicity set ASPNET security settings on the mdb file, then
it works fine. Any ideas?

Thanks.
 
This is yet another reason NOT to use JET/Access databases on a web site.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
 
Back
Top