Access database connection shutdown and. ldb File Locking Workaround

Source: Internet
Author: User

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.