Access Locking Problem

[Miky]

Hi,

I wrote a data-entry application that has to be used by 80
people and it is using databinding to the dataset. When we
were making the test on multiple machines, the application
locked stating that the record that it was trying to
access was locked by another machine (probably stored in
the same memory page). The database is in Access.

Wasn't .NET supposed to be a disconnected environment?

Do I have to move out from the databinding and manage the
connection myself?

Hope you can help me out of this soon.

Thanks,
ME-LDV

 

[One Handed Man [ OHM# ]]

You would be best places putting this query to the framework.adonet newgroup
where you are likely to get a fast reponse.

Regards - OHM

 

[Herfried K. Wagner [MVP]]

I wrote a data-entry application that has to be used by 80
people and it is using databinding to the dataset. When we
were making the test on multiple machines, the application
locked stating that the record that it was trying to
access was locked by another machine (probably stored in
the same memory page). The database is in Access.

Wasn't .NET supposed to be a disconnected environment?

Do I have to move out from the databinding and manage the
connection myself?

Which database do you use?

You will more likely get an answer here:

ADO.NET group:

<
Web interface:

<http://msdn.microsoft.com/newsgroup...roup=microsoft.public.dotnet.framework.adonet>

 

[Glenn Wilson]

I would first off start looking into MSDE or SQL Server,
using Access for a Data Entry App that multiple people
use can cause lots of problems with locking.

GW

 

[scorpion53061]

Glenn,

See Kevin and mine response to you in the ADO.NET newsgroup.