Avatar of Murray Brown
Murray Brown
Flag 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
Microsoft AccessVBA

Avatar of undefined
Last Comment
Murray Brown

8/22/2022 - Mon
SOLUTION
Ryan Chong

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
SOLUTION
John Tsioumpris

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
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
Jim Dettman (EE MVE)

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
Ryan Chong

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
Armen Stein - Microsoft Access MVP since 2006

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
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
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
Jim Dettman (EE MVE)


 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.

Murray Brown

ASKER
Thanks for the advice