hk_vic

Hi,

I am really new to SQL Server 2005 Express (I have just used the Access db in the past).
Now I would like to make a multi-user program that use a server database (so that people from diff. computer can access the data), but I would like to ask how to solve the problem of like the following?

Case:
User A get data from the server for modifying /deleting, but at the same time User B get data from the server for reading. After A modified/deleting the data, User B is not viewing the most updated data...

I have read the Microsoft onlines book about SQL Server 2005 Express and knew that there is a method call Replication. But the onlines book of sql express told me that sql express cannot act as Publisher and distributor, is that I cannot use sql server 2005 express act as the server and solve my case?

By the way, is there any other good books about SQL Server 2005 Express?

Please help..........I have stucked at this for nearly 2 weeks........

MKoslof

OK, what is your main concern? Replication or user concurrency these are seperate issues/not exactly the same . This question:

Isn't neccesarily a replication issue, this is why SQL Server provides various levels of locking and transaction isolation. SQL Server Express can act as a server or shared repository of data with no issues. SQL Server 2005 Express has lifted the "user governor" or the previous limits of 5 concurrent users at once. You shouldn't run into real stress level or performance problems until your concurrent user count is something like 20-25, if I had to guess.

What you want to review are the different user concurrency and "stale data" approaches - - or basically verifying the user's don't step on each other in a concurrent multi-user environment.

hk_vic

Hi MKoslof,

Thanks for your help, I think I really get lost in the past 2 weeks. Now with your help I think I know what I want and find some useful link from the MSDN by searching Concurrency Sample

Following is 2 link that I found useful. Hope it can help others.

http://msdn.microsoft.com/msdnmag/is...09/datapoints/
http://msdn.microsoft.com/msdnmag/is...10/datapoints/

MKoslof

Great, glad to help. Let us know if you need more assistance. Good luck