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 4 1090
You would be best places putting this query to the framework.adone t newgroup
where you are likely to get a fast reponse.
Regards - OHM
Miky wrote: 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
--
Best Regards - OHM
O_H_M{at}BTInte rnet{dot}com
* "Miky" <le******@davin ci.com> scripsit: 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:
<news://msnews.microsof t.com/microsoft.publi c.dotnet.framew ork.adonet>
Web interface:
<http://msdn.microsoft. com/newsgroups/default.asp?url =/newsgroups/loadframes.asp? icp=msdn&slcid= us&newsgroup=mi crosoft.public. dotnet.framewor k.adonet>
--
Herfried K. Wagner [MVP]
<http://www.mvps.org/dotnet>
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 -----Original Message----- Hi,
I wrote a data-entry application that has to be used by
80people and it is using databinding to the dataset. When
wewere making the test on multiple machines, the
applicationlocked 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
theconnection myself?
Hope you can help me out of this soon.
Thanks, ME-LDV .
Glenn,
See Kevin and mine response to you in the ADO.NET newsgroup. :( -----Original Message----- Hi,
I wrote a data-entry application that has to be used by 80people and it is using databinding to the dataset. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: intl04 |
last post by:
Are there any problems with multiple user access to the same Access
database on a shared network drive? I have 'shared' chosen for
'default open mode'. As for the record locking properties, I selected
'edited record' for default record locking; also, 'Open databases
using record-level locking' is checked.
We seemed to experience difficulties in this office - just once so
far, I think - with more than one user accessing the database on a...
|
by: Leinad Kong |
last post by:
I'm using Access 2002, as front-end and back-end as well:
1) I faced database corrupted problems, when more than 1 user edit
concurrently.
I'm using All-records Locking, and open-exclusively as default.
But, still face the same problem: Database corrupted! (But, it allows
to be repaired)
2) I found that the relationship linkage between those related
tables(which corrupted) was disconnected/lost after problem (1)
|
by: Deano |
last post by:
I use the Access 2000 MSI Wizard from Sagekey and they don't know if the bug
documented on page 32 of the Access 2000 Developer`s Handbook Volume 2:
Enterprise Edition still affects the runtime.
Apparently page locking is invoked when using the Access run-time record
than record-level locking. This also affects Access 2000 but if you patch
Access the bug is fixed. I really don't know about the runtime though.
Does anyone know if...
|
by: Mathieu Trentesaux |
last post by:
Hello
I downloaded Office 2007 for this reason :
It seems, once again, that it is impossible to save any modification
done in a VBA library, from the main project in Access.
The save button remains desperatly grayed.
It also seems impossible to open the library in another Access instance
|
by: shineofleo |
last post by:
Here is the situation: I wrote a VB programm, which stores all the
information in a single Access database file using jet engine. It
worked well, however one of my customs reported that there was some
problems with this programm. I checked, the log files showed that the
database was corrupted.
The customer told me that there no 'illegal' operation such as pull out
the plug, or kill the programm via task manager...
So is there any...
| |
by: Owen Jenkins |
last post by:
Following on from an earlier post...
I can reliably corrupt a record by doing the following ...
Open two separate but identical front ends on one PC each linking to the
same back end.
Edit a records in one front end and leave it unsaved.
Edit the same record in the other front end and save the change.
Save the change in the first front end - this pops up the Write Conflict
message to which I click Save.
|
by: Cindy Huyser |
last post by:
I have an Access 2000 database behind a threaded Java application that
that can have have concurrent access to the same table (but not the same
record). The database is set up for shared access with "No locks" as the
default, so that optimistic record locking should take place, and "Open
databases using record-level locking" is selected. Each Java thread gets
a new connection to the database, then updates its record.
One of my users has...
|
by: Djblurr |
last post by:
Hi guys,
I've been stuck on this problem for days now at work and its driving me insane. Basically there is a system in place at multiple locations that is an open source project running with ms access. This system holds customer records and order data, and its written in asp.
We have a web service that sits at each of these locations written in vb.net and it is called by our system, on one of our servers. The web service is used online,...
|
by: stuart |
last post by:
I have 2 users who ran into a problem with a data entry program
(written in Access 2003). One user was keying into one of the forms
when she got the message "ACCESS Error Number: 3218 Could not update;
currently locked'. About the same time, another user was keying
records into a 2nd form. Even though they were on different forms,
they would have added records to the same table.
The 2nd user had tried to add about 28 records, the...
|
by: Sam Lambson |
last post by:
Hi,
This is similar to another post, because I still haven't gotten to the
bottom of it.
I have a back end database on a shared drive. Each (of 4) user has a
front end file on their own C: drive. The main form that users have
is bound to a query which merges 2 linked tables. It is not an action
query. When the query is executed, everyone still has access to the
form/query, until somebody makes an update. Or so it seems.
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |