Keeping a DataTable Updated from Access

Posted on 2007-10-08
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

    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

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

    Featured Post

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    Join & Write a Comment

    This tutorial demonstrates one way to create an application that runs without any Forms but still has a GUI presence via an Icon in the System Tray. The magic lies in Inheriting from the ApplicationContext Class and passing that to Application.Ru…
    Article by: jpaulino
    XML Literals are a great way to handle XML files and the community doesn’t use it as much as it should.  An XML Literal is like a String ( Literal, only instead of starting and ending with w…
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    746 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

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now