How to save to an Access Database for different directory drives

Question

0.00/5 (No votes)

See more:

C# 2008, Windows Forms, Access 2010 database.
I have a form that collects data and then saves to a directory on my computer..C:\\ drive. I am going to eventually have this application installed on different machines and have the data saved to a directory on our server. This directory may be set as the X drive on one machine and the Z drive on another. How do I do this? my current connection is written as so:

C#

OleDbConnection myConnection = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\Temp\\Test.accdb");

Posted 18-Mar-13 9:54am

kp42

Updated 18-Mar-13 10:20am

Zoltán Zörgő

v2

Add a Solution

3 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)

Jibesh · Answer 1 · 2013-03-18T10:28:00

Solution 1

The simplest way would be having the database path as a configurable item in your application and refer that value to build your connection string.
If the config item is not available use a default path defined by your application.

some samples
How to get Connection String from App.Config in c#[^]

provide a settings UI to modify this path by the users if they want to change this path later time.

Posted 18-Mar-13 10:28am

Jibesh

Updated 18-Mar-13 10:30am

v2

Comments

kp42 21-Mar-13 13:40pm

How is the OleDBConnection to be written after following this sample? OleDbConnection myConnection = new OLleDbConnection(??); I tried using "connectionString", but I receiev an error that the ConnectionString property has not been initialized.

Sergey Alexandrovich Kryukov · Answer 2 · 2013-03-18T10:31:00

Solution 2

Did you ever think on using database with client-server architecture? And it even can be light-weight and not proprietary as Microsoft Access is. You see, file-based (or fileserver-based) Access will lead you nowhere.
This is the first problem you can see, further problems may haunt you badly.

Please see:
http://en.wikipedia.org/wiki/Microsoft_Access[^],
http://en.wikipedia.org/wiki/Client-server[^].

—SA

Posted 18-Mar-13 10:31am

Sergey Alexandrovich Kryukov

Updated 18-Mar-13 10:32am

v2

Comments

kp42 21-Mar-13 13:42pm

Thanks for the links, but how would you go about doing this?

Sergey Alexandrovich Kryukov 21-Mar-13 14:53pm

My advice would be migrating to client-server. Consider MySQL, SQLLite, MS SQL Express, MS SQL, whatever. Please see:
http://en.wikipedia.org/wiki/List_of_relational_database_management_systems

—SA

**Zoltán Zörgő** · Answer 3 · 2013-03-18T10:32:00

Build your connection string at runtime.
Use GetEntryAssambly[^] and it's Location[^] property.

C#

using System;
using System.IO;
using System.Reflection;

namespace My
{
	class Program    
	{
		public static void Main()
		{
			string folder = Path.GetDirectoryName(Assembly.GetEntryAssembly().Location);
			string filename = Path.Combine(folder, "text.accdb");
			string connectiostring = String.Format("Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0}",filename);
			
			Console.WriteLine(connectiostring);
		}
	}
}