Link to home
Start Free TrialLog in
Avatar of Murray Brown
Murray BrownFlag for United Kingdom of Great Britain and Northern Ireland

asked on

Access VBA

Hi

What VBA code would I use to detect any table or column differences between two Access databases. I am looking at two versions of the same back end and constantly need to check this

Thanks
SOLUTION
Avatar of Ryan Chong
Ryan Chong
Flag of Singapore image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Bill Prew
Bill Prew

At the risk of being the person that always asks questions, what specifically do you mean by "detect any table or column differences between two Access databases"?


I can see several interpretations, like:

·       Comparing two databases in their entirety identifying tables and columns present in one and not the other, or columns that have different schema definitions (type, scale, null, etc)

·       Comparing two tables with the same name between databases looking for schema differences

·       Comparing two tables with the same name between databases looking for data content differences

·       . . .


»bp


SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
you could also export your data out to Excel, and do cell matching, which is fast and easy, if that make sense to you.
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Murray Brown

ASKER

Hi
I was hoping that there would be VBA code to do this
I am working with a database backend where tables and columns are altered regularly on the front end then need to be changed
on each customer backend at different times
Thanks


 Years ago, there was a product called "Data Angel", which did just this.   But it never took off, why?    Because in a well designed DB, it's rare to have to actually alter tables and when you do, often it involves much more than simply altering fields.   Data typically needs to be transformed as well (i.e. you put in a new invoicing system, changing all the tables).


 So there is no "one size" fits all type of approach.


Jim.

Thanks for the advice