Access database connection shutdown and. ldb File Locking Workaround

Intermediary transaction http://www.aliyun.com/zixun/aggregation/6858.html ">seo diagnose Taobao guest cloud host technology Hall

These days has been the ASP call database caused CPU utilization up to 100% of the problem, just finally solved the problem, you can sleep a good night!

Common Database connection methods:

Dim ConnStr

Dim DBPath

Dbpath= "#123 $asd 31.mdb"

Connstr= "Provider=Microsoft.Jet.OLEDB.4.0;Data source=" & Server.MapPath (DBPath)

Set conn = Server.CreateObject ("ADODB. Connection ")

Conn. Open ConnStr

Closing the statement is not just.

(Disconnect record)

Rs.close

Set rs=nothing

Also: (disconnect)

Conn.close

Set conn=nothing

After excluding the above reasons.

Open your database with access, select the Tools]->[option in the menu]->[advanced

Change [default open mode] to [share], change [default record lockout] to [do not lock].

If you still do not, the option below [using record-level locking] is also canceled.

OK after saving, then open, repair/compress the database.

Delete the ldb file in the directory (if you cannot delete it, end the related process or restart the computer deletion)

8630.html "> Sometimes check whether there is a page at the same time competing for resources, my problem is caused by this situation!" Welcome to guide our website: (jining website construction expert-Yi Yuan Network) http://www.05371.com