Where to keep the MS Access DB file in the project folder.

Question

0.00/5 (No votes)

See more:

Hello everyone,

I m working on the project in vc# connecting to MS Access db. My project is almost complete but i m facing a problem that whenever i m carrying my project to another system i need to keep it 2 the same path as i had it at my system(eg: in my system i have made this project under the folder D:\proj.) So on each and every system i need to keep my project under this location only.

Please assist me by telling the exact location where i should keep my DB so that whenever i m carrying my project to another system, it should work fine irrelevant of the location where i have kept it.

:(

Also Please tell me the connection string for it.

Bye

Posted 9-Jan-10 8:43am

SPaRTaNS_NiK

Add a Solution

2 solutions

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)

Dimitri Witkowski · Answer 1 · 2010-01-09T08:51:00

Solution 1

I would advice you one of the following:
1. In the application folder (where your exe is located): then you can write as follows: .\mydb
2. In the User\AppData folder. You can use google and find how to use it.

Posted 9-Jan-10 8:51am

Dimitri Witkowski

Abhishek Sur · Answer 2 · 2010-01-09T09:39:00

I think you might create one installer that places the db to the target location.

Or you might also use app.config to define the path of the file where it is located.

Generally we place the database file in the same folder as to have better access. You might also use any path. Just place it anywhere where you want and edit app.config with path of the file:

<br />
<appSettingss><br />
<add key="dbPath" Value="C:\x\y\db.mdb">

Now in your code replace the filepath in the connection string with
ConfigurationSettings.AppSettings ["dbPath"];

:thumbsup: