ADIGA88
Member
- Local time
- Tomorrow, 00:05
- Joined
- Apr 5, 2020
- Messages
- 93
Hi guys,
I am looking for a way to compare two databases tables, queries (fields names and properties) programmatically the scenarios as follows:
I have an access application in production I developed a while ago, and for my last modifications I outsource the development to a freelancer, but the issue now there are differences in tables and queries, I want a way to programmatically discover those changes.
The Pathways I am considering:
1. exporting tables and queries definitions using "Database Documentor" in XML format (by the way I am getting an export Error when trying XML) and comparing outside.
2. a second idea came to me while writing this post to use Tabledef and Query def in DAO (but here I need to merge the two DBs for the comparison, I think).
P.S. for the first option I can't find an object for the Database Documentor in Access Namespace, the only interaction is Application.DoCmd.RunCommand acCmdDocumenter
please any advice.
Thanks
I am looking for a way to compare two databases tables, queries (fields names and properties) programmatically the scenarios as follows:
I have an access application in production I developed a while ago, and for my last modifications I outsource the development to a freelancer, but the issue now there are differences in tables and queries, I want a way to programmatically discover those changes.
The Pathways I am considering:
1. exporting tables and queries definitions using "Database Documentor" in XML format (by the way I am getting an export Error when trying XML) and comparing outside.
2. a second idea came to me while writing this post to use Tabledef and Query def in DAO (but here I need to merge the two DBs for the comparison, I think).
P.S. for the first option I can't find an object for the Database Documentor in Access Namespace, the only interaction is Application.DoCmd.RunCommand acCmdDocumenter
please any advice.
Thanks