Click here to Skip to main content
12,452,344 members (53,685 online)
Rate this:
 
Please Sign up or sign in to vote.
See more: C#
Hello friends I Using microsoft access 2007 as Database

I Have 5 PC In LAN I wanted to Use Only One Database but My Project In All 5 PC's,

There Is No Problem In Sql Server But I Am New in MS Access

So Looking For Detailed Information Of Connection String or solution..

Looking for your help

Thanks
Posted 7-Jan-13 19:46pm
Updated 7-Jan-13 20:04pm
v2
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

Hi,

MS Access is not a better solution for Shared Database.
Access have many concurrency problems but I dont think it will crash for 5 concurrent users if your user count exceed then you may have problem.

But as you wish

http://www.microsoft.com/en-us/download/details.aspx?id=23734[^]

Basic OF Ms Access
http://www.c-sharpcorner.com/uploadfile/puranindia/ado-net-application-using-ms-access-2007-database/[^]

http://richnewman.wordpress.com/2007/08/25/a-beginner%E2%80%99s-guide-to-calling-a-net-library-from-access/[^]
  Permalink  
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 2

Thanks For Reply But I'll Solved ....

I Put My Main PC's Connection String And It will Solved...


Ans Is :

public static string strFile = @"\\[IP Address]\[Share Folder Name]\Project\Database\dateBaseName.accdb";
  Permalink  
v2

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy | Mobile
Web02 | 2.8.160826.1 | Last Updated 8 Jan 2013
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100