File in use error

N

Nathan Sokalski

I am recieving an error about not being able to use a file because it is
already in use. Based on the error, I think it is referring to my DB, but I
don't know how to avoid the error or why it is happening. Here is the error:
Server Error in '/LVBEP' Application.
--------------------------------------------------------------------------------

Could not use ''; file already in use.
Description: An unhandled exception occurred during the execution of the
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 OleDb.OleDbDataAdapter("SELECT *
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(Int32 hr) +20
System.Data.OleDb.OleDbConnection.InitializeProvider() +57
System.Data.OleDb.OleDbConnection.Open() +203
System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection,
ConnectionState& originalState) +44
System.Data.Common.DbDataAdapter.FillFromCommand(Object 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
 
S

Scott Mitchell [MVP]

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 said:
I am recieving an error about not being able to use a file because it is
already in use. Based on the error, I think it is referring to my DB, but I
don't know how to avoid the error or why it is happening. Here is the error:
Server Error in '/LVBEP' Application.
--------------------------------------------------------------------------------

Could not use ''; file already in use.
Description: An unhandled exception occurred during the execution of the
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 OleDb.OleDbDataAdapter("SELECT *
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(Int32 hr) +20
System.Data.OleDb.OleDbConnection.InitializeProvider() +57
System.Data.OleDb.OleDbConnection.Open() +203
System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection,
ConnectionState& originalState) +44
System.Data.Common.DbDataAdapter.FillFromCommand(Object 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
Click to expand...
 
N

Nathan Sokalski

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
(e-mail address removed)
http://www.nathansokalski.com/

Scott Mitchell said:
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 said:
I am recieving an error about not being able to use a file because it is
already in use. Based on the error, I think it is referring to my DB, but
I don't know how to avoid the error or why it is happening. Here is the
error:
Server Error in '/LVBEP' Application.
--------------------------------------------------------------------------------

Could not use ''; file already in use.
Description: An unhandled exception occurred during the execution of the
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 OleDb.OleDbDataAdapter("SELECT
* 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(Int32 hr) +20
System.Data.OleDb.OleDbConnection.InitializeProvider() +57
System.Data.OleDb.OleDbConnection.Open() +203
System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection,
ConnectionState& originalState) +44
System.Data.Common.DbDataAdapter.FillFromCommand(Object 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
Click to expand...


--

Scott Mitchell [ASP.NET MVP]
(e-mail address removed)
http://www.4GuysFromRolla.com/ScottMitchell
Click to expand...
 
M

Mark Rae

Source File: C:\Inetpub\wwwroot\LVBEP\memberadmin.aspx.vb Line: 43
Click to expand...

1) Is Server.MapPath("LVBEP.mdb") pointing to a valid database?

2) Does the ASPNET account have sufficient permissions to do what you want
i.e. specifically to create the .ldb file which Jet uses for locking
purposes?
 
N

Nathan Sokalski

Yes, it is pointing to a valid DB (not to mention if the DB was not ther it
would say something like file could not be found). I have also given the
ASPNET machine account access to the database. I have used the database
before in this application, but something, I don't know what, caused it to
start giving this error. I am simply having trouble finding the source of
the error (where/what in my code is causing the problem?) Thanks.
 
P

Pipo

If you right click on the access DB and choose for properties is the
checkbox 'read-only' checked?
If so uncheck it.


Nathan Sokalski said:
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
(e-mail address removed)
http://www.nathansokalski.com/

Scott Mitchell said:
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
Click to expand...
------------------------------------------------------------------------- -------
Could not use ''; file already in use.
Description: An unhandled exception occurred during the execution of the
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 OleDb.OleDbDataAdapter("SELECT
* 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(Int32 hr) +20
System.Data.OleDb.OleDbConnection.InitializeProvider() +57
System.Data.OleDb.OleDbConnection.Open() +203
System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection,
ConnectionState& originalState) +44
System.Data.Common.DbDataAdapter.FillFromCommand(Object 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
Click to expand...
Click to expand...
------------------------------------------------------------------------- -------
Version Information: Microsoft .NET Framework Version:1.1.4322.2032;
ASP.NET Version:1.1.4322.2032
Click to expand...


--

Scott Mitchell [ASP.NET MVP]
(e-mail address removed)
http://www.4GuysFromRolla.com/ScottMitchell
Click to expand...
Click to expand...
 
B

Bob

Nathan:

Make sure your closing your connection after you access your data in your
code.

Look for a file LVBEP..ldb on the server in the same dir as the LVBEP.mdb
file. If it it's there, delete it.

If you have access to the IIS Administrator, open the IIS Admin.

Right click the site and click properties. Click the "home Directory" tab
and click the "Unload" button then delete the LVBEP.ldb file.

Then try your connection again. As I said, make extra sure your closing the
connection in your code.

MyOLEDBConnection.Open()

Fill your dataAdapters

MyOLEDBConnection.Close()

By chance, your not developing against a DB that is also in production are
you?

Make sure your Access file is not in the root. Put it in a sub dir of the
root and don't give the "Everyone" account read permissions.

Be sure not to load data directly into a session object. Use sessions
sparingly.

HTH

Bob
 
P

Patrick.O.Ige

When the Access databse file is opened..i think it also opens
anothe file called ldb ir something try deleting it..
Not really sure if that would help but i had the same issues before
Patrick
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ASP.net and Oracle error System.Data.OleDb.OleDbException 5
Server Error in '/' Application. 0
SQLConnection Help 1
[OleDbException (0x80004005): Unspecified error] 7
Issue with importing CSV file using JET. Error Message: 'Cannot update. Database or object is read- 1
Deploy web app. with Oracle Client on a different drive than the a 0
Server Error in '/Access' Application 9
asp.net 1.1 can't connect to any sql server 1

Members online

Total: 47 (members: 1, guests: 46)
Robots: 357

Forum statistics

Threads
473,968
Messages
2,570,154
Members
46,701
Latest member
XavierQ83

Latest Threads

Top