Concurrency with win forms app and Access

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rotsey - 04 Jul 2007 03:13 GMT

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

Reply to this Message

Alvin Bruney [MVP] - 04 Jul 2007 15:28 GMT

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.

Signature

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

> Hi,
>
[quoted text clipped - 11 lines]
>
> Malcolm

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...