Link to home
Start Free TrialLog in
Avatar of Sandesh555
Sandesh555Flag for India

asked on

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.

Thanks,
Sandesh.
Avatar of HainKurt
HainKurt
Flag of Canada image

not clear enough for me to say anything...
Avatar of Sandesh555

ASKER

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.
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.
ASKER CERTIFIED SOLUTION
Avatar of danishani
danishani
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial