How do I check if the given Record is already updated in Access Database.

Posted on 2011-05-05
Last Modified: 2012-05-11
Hi Team,
I am new to Access.
I am writing a program in VBA Access.  I have a updated set of records in my table.   Now I have to make sure when I run code to update new repords only unique new records should be updated.

I already have a column in my database which houses these unique records.

Question by:Sandesh555
    LVL 51

    Expert Comment

    not clear enough for me to say anything...

    Author Comment

    For Example the table I have create contains list of emails sent to me in my Inbox.    Now every time I run the code to update the details of these emails into my access database, my code should only add the records for new email.

    Note the code to extract the email details runs every 15 minutes.

    Author Comment

    When the code runs it runs on the entire Inbox and not jsut on the new work items.

    So I want only the new emails to get added to my database in Access.
    LVL 12

    Accepted Solution

    Well if I understand you correctly you want to Update- and-or Insert new records into your Table.

    These are two different things, and handled in two different ways. So its either you do an Update Query for updating your data, or Instering New data into your Table using an Append Query.

    So based on that, you need to create to Seperate Query´s achieving the goal you are after.


    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    Join & Write a Comment

    Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
    Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
    Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
    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…

    755 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

    24 Experts available now in Live!

    Get 1:1 Help Now