Desktop application without installing MS Access 2007

Question

1.00/5 (1 vote)

See more:

Hello,

I am developing one C# Windows Form application for 10-15 clients on LAN, but have few doubts -
For Back-end Database - my client don't want other than access as database.

My query is without installing MS Access 2007 OR Access DataBase Engine, whether my application can use Access Database File through any reference from .Net Framework 4.0( I will defiantly install .Net4.0 Framework).

Please let me know if this is possible!!!

Thanks in Advance!!!

Posted 7-Jul-13 19:43pm

Pravinkarne.31

Add a Solution

Comments

Sushil Mate 8-Jul-13 1:59am

install MS access on server & you can access that DB from other system through LAN. no need to install on every machine.

bbirajdar 8-Jul-13 2:34am

right

Pravinkarne.31 8-Jul-13 3:10am

You mean to say that, I don't have to install even Access Database Engine on client Machine?
and without installing access on client machine - my excel will read and right access database 2007 file?

Sushil Mate 8-Jul-13 4:39am

yes

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)

Maciej Los · Accepted Answer · 2013-07-08T01:10:00

You don't need to install MS Access drivers on each client. .NET drivers (OLEDB/ODBC) provide the ways to read and write form/to Access database.

Have a look here:
Creating & Retrieving records from M.S.Access-2007 using Oledb in C#.net[^]
OLEDB tutorial (C#)[^]
OLE DB Consumer using basic C#[^]
Using ADO.NET for beginners[^]
ADO.NET[^]
ADO.NET Code Examples[^]

Place the database on server folder (share it in LAN) and map this folder on local machines (for example as a Z: drive), then use it in connection string ;)