Determine Changes in Database

I

IComeInTheWest

Greetings,

Each week our corporate office sends me an updataed database. I'd like
a way to determine exactly what changed between two databases. Any
ideas?

I'm not too experienced with access, but have programmed in Excel VBA
and like to think that I have a high "computer IQ." So please feel
free to give me the best answer; I will ask questions and research as
necessary.

Thanks,

Calvin
 
A

Aaron Kempf

if you think that you've got a high computer IQ because you use Excel?

then you should go and test your 'high car IQ' by trying to play frogger in
the freeway
 
A

Aaron Kempf

lose the training wheels and 'learn a database'

I would reccomend learnnig a REAL database

for example-- SQL Server has this concept called 'DDL Triggers' so that you
can now 'keep track of table changes'

it is quite easy to do
but you've got to use SQL 2005

and 'Im an Excel _GENIUS_' is nothing but a big fat target on your back


Excel is worse than pen and paper-- what did you do, break a wrist from
using copy and paste too much?
 
J

John W. Vinson

Greetings,

Each week our corporate office sends me an updataed database. I'd like
a way to determine exactly what changed between two databases. Any
ideas?

I'm not too experienced with access, but have programmed in Excel VBA
and like to think that I have a high "computer IQ." So please feel
free to give me the best answer; I will ask questions and research as
necessary.

Thanks,

Calvin
Click to expand...

If it's just a table - rather than a full Access database, with multiple
tables, forms, reports, etc. - you can create a Query joining the old table to
the new table by some appropriate field and search for differences.

If it's a database, and they might have added a new form or deleted records in
this table and edited records in that table... it's tougher. You can purchase
"Total Access Detective" from FMS Inc (www.fmsinc.com); it's a powerful
database comparator.

Apologies on behalf of the volunteers here for Aaron's trolling.

John W. Vinson [MVP]
 
I

IComeInTheWest

lose the training wheels and 'learn a database'

I would reccomend learnnig a REAL database

for example-- SQL Server has this concept called 'DDL Triggers' so that you
can now 'keep track of table changes'

it is quite easy to do
but you've got to use SQL 2005

and 'Im an Excel _GENIUS_' is nothing but a big fat target on your back

Excel is worse than pen and paper-- what did you do, break a wrist from
using copy and paste too much?








- Show quoted text -
Click to expand...

I formally retract my belief that I have a high computer IQ. I realize
now that I am but a worthless Excel user. Thank you, Aaron Kempf, for
showing me the light.
 
A

Aaron Kempf

any time

I would rather use MDB than Excel-- and we all know how much I hate MDB
 
Top