INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Find the latest records on duplicate tables

Find the latest records on duplicate tables

(OP)
I have created an access database in a shared drive so that employees can enter their production data, and the bosses to view the report.

One of the employee drag and drop this access file to his folder on his computer creating a duplicate database. He has entered over a thousand new record on this database (the one on his desktop).

How do find out which records are missing from the one on the shared drive? And how to I transfer those records to the one on the shared drive?

Please help!

RE: Find the latest records on duplicate tables

Hi,

I would not reward bad behavior.

He's got to enter the data in the correct manner himself!

RE: Find the latest records on duplicate tables

This is one of the reasons why we recommend splitting your applications into front-end and back-end files. They can copy and/or delete their copy of the front-end without having any adverse issues with the back-end tables.

Without understanding your tables and relationships, it is impossible to suggest a strategy other than Skip's tough love advice winky smile

Duane
Hook'D on Access
MS Access MVP

RE: Find the latest records on duplicate tables

just link to both databases. Then do an outer joing linking his tables to your tables. Pick a field from your table and set the criteria to null. This will return all records in his table not in your table. Do an insert query. You will have to do this for all possible tables that could have inserts.

RE: Find the latest records on duplicate tables

(OP)
@SkipVought, I wouldn't either but my boss told me to fix his mess.

@dhookom, I'll do that next time.

@MajP, thanks for the tip, I'll give it a try.

RE: Find the latest records on duplicate tables

MajP's suggestion will work well for a simple database that doesn't use autonumbers and foreign keys in related tables. Again, without additional information about your tables and relationships, we can't provided much more guidance.

Duane
Hook'D on Access
MS Access MVP

RE: Find the latest records on duplicate tables

So on Duane's point for all tables with autonumbers you will have to add a field on your table called something like "hisAutonumber" to store his old primary key. And when you do you insert query into your main table you need to put his autonumber into the "hisAutonmuber" field. Now you will have a new PK and a field with the old PK. You will need this old value to match with the new autonumber when you upate the child tables. Then to update the child tables you link on the "hisAutonumberField" the old primary key. Then you do an insert query into your child table, inserting the new primary key autonumber as the foreingn key in your child table. This is doable but as said you could have hundreds of tables with multiple autonumber fields. As people said. ALL Access multi user applications should be split into Front ends maintained on the local machine and a single back end on the server.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close