duplicate files. User error/s

  • Thread starter Thread starter sherril
  • Start date Start date
S

sherril

Hello everyone. I was wonering if anyone knew of a
shortcut to fixing a problem that I created myself. A long
story short-I and others have all (4 of us) loaded a group
of database files (946 of them) onto my home PC. These are
therfore duplicated four times. Sounds like a simple
delete doesn't it. No.... We easch have done some
alteration to various databases and then loadded them in
different places on the same PC.So... what I am after is a
way to search and locate all database files on my PC and
then find a magic way of merging all the differences into
one set of the databases and landing them all together in
one location. Clutching at straws I know But... one never
really knows until they ask. One thing is for sure and
that is I am glad no one on here knows me cause I feel
like an idiot. Such a comedy of errors that has landed me
in the labourious predicament.Help.... Sherril
 
Hi Sherril,
Not sure how much you know about windows, so forgive me if I'm telling you
things you already know!

You could use Window's search function to find all the databases:
START -> Search -> 'For Files or Folders'

Search for files or folders named : *.MDB

This should find ALL the access database files on your PC. Beware there
could be more than just the ones you are looking for.

Hopefully you will be able to identify the ones that you need.

I would suggest that you then COPY each into a directory that you create
called (say) DatabaseFix.

You could then create a new database in this directory, and create linked
tables in here from each of the tables in each of the databases.
Once you have done this, you will have all the tables in one place, and you
should be able to create some queries to try and stitch things back
together.

If, having got to this point, you are still a bit stuck, Post back here, and
I'm sure someone will be able to help you finish it off.

Finally, how can you be sure that no-one know you?

....aren't you that Sherril that..... only joking! ;-)

Good luck with your database(es)

ChrisM.
 
Just re-read your post.

946 Databases!! hmmm....What on earth are are they all???

So it's not quite as straight forward as I thought, but I think my basic
technique is your only real chance.

(unless someone-else knows better - which is quite likely!)

ChrisM
 
Back
Top