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"