Connection string to access database in Program files

Question

I am working on windows form which uses microsoft access database.

When the application will be installed, the database will be on this location C:\Program Files (x86)\Amrit\trial\Database.

How can i make this work so that this application will linked to the database when installed in my computer.

Can somebody give me easy solution.. Currently my connection string looks like this..

string connString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\Users\\Amrit\\Desktop\\Database.accdb ;Persist Security Info=False;";

when i create setup file for appplication, the database will be in ProgramFiles/AmritCreations/AppName/Database.accdb

enter image description here

Please give more details.

linguini
– linguini

2013-02-15 07:20:15 +00:00
Commented Feb 15, 2013 at 7:20 — linguini
– linguini, Commented Feb 15, 2013 at 7:20

spajce · Accepted Answer · 2013-02-15 08:54:38Z

1

Just place your database and your application in the same directory and use this connectionString

string connString = "Provider=MICROSOFT.ACE.OLEDB.12.0; " +
                    "Data Source=|DataDirectory|/Database.accdb";

In times you're creating a Setup Project, try to place the database file and [yourProjectName].exe in the same directory.

edited Feb 15, 2013 at 8:54

answered Feb 15, 2013 at 6:57

spajce

7,0905 gold badges31 silver badges46 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

spajce Over a year ago

thats strange.. can you please give some more details about your problem? and when you use the connectionString from my answer.. what is the error?

Amrit Sharma Over a year ago

before i can create setup file for the application, i changed the connection string as string connString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|/Database.accdb ;Persist Security Info=False;"; and then i created the set up file where i put my databse in this location. ProgramFiles/AmritCreation/MyAppName/..

spajce Over a year ago

Did you try to place your database and your application.exe in the same folder?

Amrit Sharma Over a year ago

Both are inside the My Product Name Directory..Please check pic above

spajce Over a year ago

okay.. again try to place your database file and your running application.exe in the same directory.. I mean try move your database file in that folder Project Management. or in Bin folder in the project solution and use the connectionString above

Collectives™ on Stack Overflow

Connection string to access database in Program files

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related