Concurrency with 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

 

[Scott McDaniel]

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.

The Jet database handles concurrency pretty well IF you have setup the relationships correctly. For example, Jet won't
allow you to add a Child record if no Parent record is present. If you haven't setup your relationships correctly, then
your code must handle these matters.

If your code must handle them, then you'd have to put code in both places to do this, or setup some sort of "middle
tier" application which both frontends go through before doing data manipulation. Not sure how you'd do this, but it
could be something like a dll that both FEs could talk to that would insure data integrity and concurrency before it
gets to the database.

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

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com