Unknown user keeps access db open - CAN'T MODIFY

Discussion in 'Databases' started by jaycast, Feb 1, 2005.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. jaycast

    jaycast

    I'm trying to run access structure modifications, however every time I try to modify/delete/add a column, I'm met with an error saying that a user "web115" has the database open. I also notice the corresponding .ldb file in my FTP client, showing an active db session open. If I'm the only one accessing that database and all my connections are closed, how can it still be open?

    Please help! This is whittling away my dev time.

    Thanks
     
    jaycast, Feb 1, 2005
    #1
  2. Bruce

    Bruce DiscountASP.NET Staff

    Make sure you close your database connections in all your page.

    Are you using ASP.NET? If so, make sure you put the db close function in your error trapping code.

    Try

    ' Do something....

    Catch
    ' Catch your error

    Finally
    ' Close your DB connection here
    db.close

    End Try

    If you are using ASP, use On Error Resume Next and close DB connection at end of the page.

    Bruce

    DiscountASP.NET
    www.DiscountASP.NET
     
    Bruce, Feb 2, 2005
    #2
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page