Access Table Access

  • Thread starter Thread starter Jim Heavey
  • Start date Start date
J

Jim Heavey

Hello, When I am using Asp.Net to read an Access table (from within VS.Net)
and I "quit" (close out of IE, but still in VS.Net) the application and I
attempt to open the access file in Access, I get a message which indicates
that I can only have read access as something else has a "Lock" on the
file. Even if I close out of VS.Net and do the same, I get the same error.
I have to kill the ASPNet_WP.exe thread in order to release the file. Why
is this? Is this because I am not normally closing the application (and
therefore the Access File) or is there some other reason? How can I get
around this problem without having to kill ASPNET_WP.exe?
 
¤ Hello, When I am using Asp.Net to read an Access table (from within VS.Net)
¤ and I "quit" (close out of IE, but still in VS.Net) the application and I
¤ attempt to open the access file in Access, I get a message which indicates
¤ that I can only have read access as something else has a "Lock" on the
¤ file. Even if I close out of VS.Net and do the same, I get the same error.
¤ I have to kill the ASPNet_WP.exe thread in order to release the file. Why
¤ is this? Is this because I am not normally closing the application (and
¤ therefore the Access File) or is there some other reason? How can I get
¤ around this problem without having to kill ASPNET_WP.exe?

How are you opening the Access database?


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)
 
How are you accessing the data? Through automation or ADO.NET? You
need to explicitly close any adonet connections or use the
Marshal.ReleaseComObject method if you're using automation.

--Mary
 
Back
Top