C# windows application MS-Access backend Connection string for Cleint Mechince on LAN

Question

0.00/5 (No votes)

See more:

hi all

i develop a small application in C# MS-access a backend. am using connection to connect the Ms-Access database using the following

key="con" value="Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\MediTech\meditech.data;Jet OLEDB:Database Password=123456"

i work fine in Local Mechine.
But how do i write the Connection string for Client Mechine to connet database based on the above path.

should i deploy the seperate setup for clent mechine .

how to coneect the local database from Client Mechine.

Please Guide Me

thanks

Posted 25-Nov-12 20:15pm

supershaik

Updated 27-Nov-12 2:13am

v5

Add a Solution

Comments

tanweer 27-Nov-12 8:14am

you should have the database on the client machine as well

loctrice 27-Nov-12 8:45am

Yeah, or map the network drive

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)

CafedeJamaica · Answer 1 · 2012-11-27T03:24:00

Solution 1

You have to map the network drive to where you have you database or move your database to the machine where you have your application installed.

Posted 27-Nov-12 3:24am

CafedeJamaica

Comments

supershaik 28-Nov-12 1:33am

i have database on local machine. but i would connect to server machine database form client machine using connection string code.

[no name] 28-Nov-12 10:23am

then i suggest you share the folder where you have your DB on the local network and use the network address for the DB address