ReadOnly was not checked.
--
Nathan Sokalski
njsokalski@hotmail.com http://www.nathansokalski.com/
"Pipo" <NoSpam@me.com> wrote in message
news:OSRh%23$OvFHA.3792@TK2MSFTNGP10.phx.gbl...[color=blue]
> If you right click on the access DB and choose for properties is the
> checkbox 'read-only' checked?
> If so uncheck it.
>
>
> "Nathan Sokalski" <njsokalski@hotmail.com> wrote in message
> news:Oo6v46KvFHA.2948@TK2MSFTNGP15.phx.gbl...[color=green]
>> I did not have Access (or any other programs that use Access or any
>> Access
>> DBs) open at the time. I even tried restarting my computer to make sure
>> nothing was running in the background, but it did not help.
>> --
>> Nathan Sokalski
>>
njsokalski@hotmail.com
>>
http://www.nathansokalski.com/
>>
>> "Scott Mitchell [MVP]" <mitchell@4guysfromrolla.com> wrote in message
>> news:UNmXe.92$9E2.31@newssvr11.news.prodigy.com...[color=darkred]
>> > Make sure your Access database file is NOT open in Windows. I.e., make
>> > sure you are closed out of it. I don't know if that's the cause of
>> > YOUR
>> > error, but I do know that things can get 'funky' if you have Access
>> > opened, inspecting/modifying your database, and you try to work with it
>> > via an ASP.NET page...
>> >
>> > hth
>> >
>> >
>> >
>> > Nathan Sokalski wrote:
>> >> I am recieving an error about not being able to use a file because it[/color][/color]
> is[color=green][color=darkred]
>> >> already in use. Based on the error, I think it is referring to my DB,[/color][/color]
> but[color=green][color=darkred]
>> >> I don't know how to avoid the error or why it is happening. Here is
>> >> the
>> >> error:
>> >> Server Error in '/LVBEP' Application.[/color]
>>[color=darkred]
>>> -------------------------------------------------------------------------[/color][/color]
> -------[color=green][color=darkred]
>> >>
>> >> Could not use ''; file already in use.
>> >> Description: An unhandled exception occurred during the execution of[/color][/color]
> the[color=green][color=darkred]
>> >> 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: Could not use '';
>> >> file already in use.
>> >>
>> >> Source Error:
>> >>
>> >> Line 41: Dim memberadapter As New[/color][/color]
> OleDb.OleDbDataAdapter("SELECT[color=green][color=darkred]
>> >> * FROM members ORDER BY name", "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA
>> >> SOURCE=" & Server.MapPath("LVBEP.mdb"))
>> >> Line 42:
>> >> Line 43: memberadapter.Fill(members)
>> >> Line 44: datEditMembers.DataSource = members
>> >> Line 45: datEditMembers.DataBind()
>> >>
>> >> Source File: C:\Inetpub\wwwroot\LVBEP\memberadmin.aspx.vb Line: 43
>> >>
>> >> Stack Trace:
>> >>
>> >> [OleDbException (0x80004005): Could not use ''; file already in use.]
>> >> System.Data.OleDb.OleDbConnection.ProcessResults(I nt32 hr) +20
>> >> System.Data.OleDb.OleDbConnection.InitializeProvid er() +57
>> >> System.Data.OleDb.OleDbConnection.Open() +203
>> >> System.Data.Common.DbDataAdapter.QuietOpen(IDbConn ection
>> >> connection,
>> >> ConnectionState& originalState) +44
>> >> System.Data.Common.DbDataAdapter.FillFromCommand(O bject data, Int32
>> >> startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
>> >> CommandBehavior behavior) +304
>> >> System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32
>> >> startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
>> >> CommandBehavior behavior) +77
>> >> System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) +38
>> >> LVBEP.memberadmin.RefreshMembers() in
>> >> C:\Inetpub\wwwroot\LVBEP\memberadmin.aspx.vb:43
>> >> LVBEP.memberadmin.Page_Init(Object sender, EventArgs e) in
>> >> C:\Inetpub\wwwroot\LVBEP\memberadmin.aspx.vb:27
>> >> System.Web.UI.Control.OnInit(EventArgs e) +67
>> >> System.Web.UI.Control.InitRecursive(Control namingContainer) +241
>> >> System.Web.UI.Page.ProcessRequestMain() +197
>> >>
>> >>
>> >>[/color]
>>[color=darkred]
>>> -------------------------------------------------------------------------[/color][/color]
> -------[color=green][color=darkred]
>> >> Version Information: Microsoft .NET Framework Version:1.1.4322.2032;
>> >> ASP.NET Version:1.1.4322.2032
>> >
>> >
>> > --
>> >
>> > Scott Mitchell [ASP.NET MVP]
>> >
mitchell@4GuysFromRolla.com
>> >
http://www.4GuysFromRolla.com/ScottMitchell[/color]
>>
>>[/color]
>
>[/color]
