Check for - and combine - records missing from 1 DB, that need to be included in a 2nd DB

**FDibbins** · 10-18-2014, 10:08 PM

My access skills are pretty much minimal, and I have a problem that, on the face of it, sounds pretty simple.

Background...
Where I work, we work 3 shifts, 7-3, 3-11, 11-7, the date for the shift is considered as the date it starts (for 3rd shift)
Each shift completes a daily report, in an access database an ex-emplyee made up.
We have 3-4 ppl per shift, and we have 3 work locations (pc's) we can work from.
We all have a shortcut on our desktop (under our own profile), that open the DB

Problem...
1 of my colegues, instead of creating a shortcut to his desktop, inadvertantly COPIED the DB to his desk top. So, for some time, he has been unknowingly entering data/reports into his "own" version. The boss noticed some records missing and we ID'd what the problem was. He will probably tell the guy to re-type all the missing records into the DB.

Is there an *easy* way to just ID and then copy the records across from the "copy" to the "master"?

**pjwhitfield** · 10-19-2014, 06:22 AM

yeah, export the table from your colleagues database to the main one so you should end up with two tables that are structured the same (TABLEA (the one that should exist) and TABLEB (the one your careless colleague had).

You'll need to identify a uniquer field in the tables but NOT an autonumber id field as this will have gone to pot with the 2nd db being used. If one doesnt exist then you'll need to create one, maybe by appending two fields together to create a unique one. Once youve got a field (for the purposes of this example I'll call it "unqiue_field" then run a query to identify the records in tableB that arent in tableA...something like

Please Login or Register  to view this content.

then create a new APPEND query using the query above as its source and append the records to TABLEA

Check for - and combine - records missing from 1 DB, that need to be included in a 2nd DB

LinkBack

Thread Tools

Rate This Thread

Display

Check for - and combine - records missing from 1 DB, that need to be included in a 2nd DB

Re: Check for - and combine - records missing from 1 DB, that need to be included in a 2nd

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] need to be able to update records with button click and delete records sample included

mail merge (?) on certain rows of sheet with access records included too?

[SOLVED] Can check boxes be included in sorting, using VBA

Macro to increment column and copy columns to next row (check box included)

Check Box included in a formula

Bookmarks

Bookmarks

Posting Permissions