Click here to Skip to main content
Rate this: bad
good
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
Edited 7-Jan-13 20:04pm
v2
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
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  

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

  Print Answers RSS
0 _Amy 310
1 OriginalGriff 294
2 Nirav Prabtani 268
3 Sergey Alexandrovich Kryukov 211
4 CHill60 150
0 OriginalGriff 7,889
1 Sergey Alexandrovich Kryukov 7,006
2 Maciej Los 4,014
3 Peter Leow 3,708
4 CHill60 2,762


Advertise | Privacy | Mobile
Web04 | 2.8.140721.1 | Last Updated 8 Jan 2013
Copyright © CodeProject, 1999-2014
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