• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 317
  • Last Modified:

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

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.

  • 2
1 Solution
HainKurtSr. System AnalystCommented:
not clear enough for me to say anything...
Sandesh555Author Commented:
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.
Sandesh555Author Commented:
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.
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

Industry Leaders: 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!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now