Need to deploy MS Access DB

Question

I have a requirement for which I have to use MS Access as database(backend) and C# windows app as frontend. I need to deploy this application on multiuser connected on LAN. So the DB is on central sever and the app installed on indivdual machines. I tried using System DSN to connect the MS Access DB but could not. Please someone help with connectionstring.

Thanks, Kanaya

See connectionstrings.com

Fionnuala
– Fionnuala

2012-07-31 09:16:56 +00:00
Commented Jul 31, 2012 at 9:16 — Fionnuala
– Fionnuala, Commented Jul 31, 2012 at 9:16

MikeJ-UK · Accepted Answer · 2012-07-31 09:11:54Z

1

You don't say why you couldn't connect to the database, but the simplest way is to use the OleDb provider for Jet (assuming of course that you have Jet installed on the client machines)

using System.Data;
using System.Data.OleDb;

//
// Code ...
//

OleDbConnection conn = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\MyServer\Mydb.mdb");
conn.open();

//
// Use connection ...
//

answered Jul 31, 2012 at 9:11

MikeJ-UK

6203 silver badges10 bronze badges

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

7 Comments

Fionnuala Over a year ago

Or ACE for 2007 and 2010 versions.

Kenny Over a year ago

Actually I cannot connect to DB as I connot find SystemDSN on server on any workgroup machines. Also I am using ODBC for using SystemDSN

Kenny Over a year ago

It gives me error as "[ODBC Microsoft Access Driver] general error Unable to open registry key Temporary Ace DSN for process".

MikeJ-UK Over a year ago

@kanayabhattad - Have you tried a File DSN (rather than System DSN) on the server?

Kenny Over a year ago

Yes, I tried using File DSN, but as multiple user will use the database I prefer System DSN.

|

Collectives™ on Stack Overflow

Need to deploy MS Access DB

1 Answer 1

7 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Your Answer

Sign up or log in

Post as a guest

Related