[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


Keeping a DataTable Updated from Access

Posted on 2007-10-08
Medium Priority
Last Modified: 2010-04-23
Hi all,

I have a connection using Jet4.0 to an Access database in my app. Several people can be logged into it at once over a network. If one user adds a record to the Access database the other users dont see that change unless they log out of the application and back in again.
Can I keep all the users information updated easily? or is it a case of closing the Access connection and reopening it everytime I want to read from Access?
Question by:kiranboi
LVL 41

Accepted Solution

graye earned 2000 total points
ID: 20034675
This is part of the design of a "disconnected recordset" that is the model that is used by ADO.Net.   The ADO.Net model means that concurrent updates by others are not visible to your application.  That's just the way they designed it...

There are two solutions...

1) Don't use ADO.Net, and go back to using the "classic" ADO
2) Periodically have your application synchonize with the underlying database.  Generally this envolves performing an Update() followed by a Fill().  The DataAdapter is smart enough to figure out that it only needs to send/retrieve the changes to the database.

Author Comment

ID: 20039362
Ahh, i was hoping there was a simple solution. Nevermind I can find a way round that. Thanx for the advice.

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The ECB site provides FX rates for major currencies since its inception in 1999 in the form of an XML feed. The files have the following format (reducted for brevity) (CODE) There are three files available HERE (http://www.ecb.europa.eu/stats/exch…
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
When cloud platforms entered the scene, users and companies jumped on board to take advantage of the many benefits, like the ability to work and connect with company information from various locations. What many didn't foresee was the increased risk…
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…
Suggested Courses

872 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question