access database locked!!!

Discussion in 'Databases' started by clayrp, Jun 23, 2005.

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

    clayrp

    some my website crashed/went crazy when i was pressing buttons lots of times /emoticons/turn.gif now it wont load and ive had a few different error messages, but having checked the site with ftp one of my access databases appears to be locked... (there is another icon there with same name and padlock... ive tried deleting everything to just reupload the site but nothing seems to work?? might be some dodgy coding that didnt close the database properly. surely there is a way to fix this from logging onto discountasp ?

    my database navigation bar shows the following code

    Microsoft VBScript runtime error '800a01fb'

    An exception occurred: 'db.execute'

    E:\WEB\ROB1NET0000\HTDOCS\CONTENT\../includes/inc_main.asp, line 415


    other error message is


    Microsoft VBScript runtime error '800a01fb'

    An exception occurred: 'db.execute'

    E:\WEB\ROB1NET0000\HTDOCS\CONTENT\../includes/inc_main.asp, line 43

    Post Edited (Rob--1) : 6/23/2005 9:39:57 PM GMT
     
    clayrp, Jun 23, 2005
    #1
  2. Bruce

    Bruce DiscountASP.NET Staff

    your application probably crashed and left the lock on your database file.

    Try put some error checking in your code.

    eg.

    On error resume next

    ' Database query

    If err.number > 0 then

    ' throw error
    ' close database connection

    End if

    Bruce

    DiscountASP.NET
    www.DiscountASP.NET
     
    Bruce, Jun 24, 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