Determine Changes in Database

[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

 

[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

 

[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?

 

[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

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]

 

[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 -

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.

 

[Aaron Kempf]

any time

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