App. Path usage

Source: Internet
Author: User

When I started typing the first example in the Redbook, I wrote the database path as follows:

Objcn. connectionstring = "provider = Microsoft. Jet. oledb.3.51;" & "Data Source = G: \ SQL Server \ database instance 1 \ instance 01.mdb"

In this way, after I move the folder, the program path cannot be identified, leading to running errors. App. path can solve this problem well.

An app is an object that refers to the program itself. App. path is a variable value in the system. App. path is the path of the returned program (the working directory of the program, not necessarily the program path), a relative path. If the file you want to open is in the same folder as your program, you can write it as app. Path & "\ file name"

The example is changed:

Objcn. connectionstring = "provider = Microsoft. Jet. oledb.3.51 ;"&_
"Data Source =" & App. Path & "\ instance 1.mdb"

 

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.