Click here to Skip to main content
15,945,939 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
I developed Simple Windows Application....

I want to make this application used in LAN, with Centeralised DATA.
All the data would be consistent and integrity is maintained for all the users of LAN...

For this What i do?
Where I want to Kept the Database?

Thank U...

[edit]Spurious bold removed - OriginalGriff[/edit]
Posted
Updated 2-Oct-12 21:38pm
v2

1 solution

If you want multiple users to use the same database at the same time, then you don't want to look at "where do I keep the file?", you wan tto look at using a databse server, such as SQL Server or MySql instead. They are designed for multiuser environments, and take all teh pain out of the process - accessing a database file directly from multiple users is a recipe for disaster until you are extremely careful, and can cause nasty problems even then.

Both Sql Server and MySql are available in free versions, which will suffice for a small instalation (and if you have a large number of users, you REALLY need to look at a server based solution, possibly with a server farm! The higher the number of users, the more pain you will get with a direct-access solution.)
 
Share this answer
 

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900