Concurrency with win forms app and Access

[Rotsey]

Hi,

I have a Access 2003 talking to SQL 2005 express DB via
linked tables.

I also have .NET forms application that also talks to the
SQL DB.

I want to know how to handle concurrency in the .NET app.

I don't want to have to change the Access app though

Is there a method that would work for both Access and .NET?

Malcolm

 

[Alvin Bruney [MVP]]

You shouldn't have a concurrency issue in your .NET application. Concurrency
should only be an issue at the SQL Express, but that is already built to
handle concurrency. On the other hand, if you are concerned about data
staleness between what the access form sees and what the .NET form sees,
that's another issue entirely.

--
Regards,
Alvin Bruney
------------------------------------------------------
Shameless author plug
Excel Services for .NET is coming...
https://www.microsoft.com/MSPress/books/10933.aspx
OWC Black Book www.lulu.com/owc
Professional VSTO 2005 - Wrox/Wiley