How to find path of a file on any drive

Question

0.00/5 (No votes)

See more:

I have one database file "ABC.mdb" that is in DATABASE folder..This database folder is in Projects folder "Milkat"...Now what I need is,this MILKAT named folder can be placed on any drive..On Windows server 2003,The code I used runs perfect but when I copy on clients PC the same folder,error occurs saying "File not found".Below is the code to Find path of file and store it in variable..

VB

'If IO.File.Exists("..\..\Database\ABC.mdb") Then
        '    PathDB = "..\..\Database\ABC.mdb"
        'Else
        '    MsgBox("This path does not contain database.")
        '    Exit Sub
        'End If

Please help me..

Posted 21-Mar-13 1:06am

Rachna0309

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Marco Bertschi · Answer 1 · 2013-03-21T01:11:00

Solution 1

This error is caused by the use of relative paths, I suppose. Check if the relative path of the DB is the same on the client system and on the development folder.

cheers,
Marco Bertschi

Posted 21-Mar-13 1:11am

Marco Bertschi

Comments

Rachna0309 21-Mar-13 7:27am

On development PC it is,E:\Projects\Database\ABC.mdb
and On Client system it is,C:\Milkat\Database\ABC.mdb

Marco Bertschi 21-Mar-13 7:29am

And where is the executable located?

Rachna0309 21-Mar-13 7:31am

On clients PC it is in C:\Milkat
On development it is in E:\Projects\bin

Rachna0309 21-Mar-13 7:36am

Is there any better way to get path of file??

Marco Bertschi 21-Mar-13 7:37am

The Problem is that your exe is located on different places related to the database on client and dev machine.
Changing the exe's location to C:\Milkat\bin on the client machine should you help solving the problem.

Rachna0309 21-Mar-13 7:40am

But as far as I know,relative path means we dont need to specify all folders name

Marco Bertschi 21-Mar-13 8:15am

Yes. But in your case, the realtivity of the exe and the DB has changed. Your exe is looking for the db at "C:\Milkat" and not "C:\Milkat\Database" on the client machine.