cravincreeks
Technical User
Hello all,
I'm developing a program that manipulates data in an Access database via ADO. This program run completely outside of MS Access application (it's executed via the VBA editor of GIS software, not Access).
In her article titled Relationships: Your Key to Data Integrity in Access , Alison Balter notes that for referential integrity to be established , the MS Access database must be open. That's no problem for me. But must the Access database be open when I insert records or otherwise update the referentially joined tables? If so, does an ADO connection string qualify as an "open" database?
I can execute my code in a manner that will update the parent table before the dependent tables and it seems that this shouldn't cause any errors due to the referential integrity. Is there anything else that I should know about manipulating referentially joined Access tables with ADO from an external program?
Thanks
AZ
I'm developing a program that manipulates data in an Access database via ADO. This program run completely outside of MS Access application (it's executed via the VBA editor of GIS software, not Access).
In her article titled Relationships: Your Key to Data Integrity in Access , Alison Balter notes that for referential integrity to be established , the MS Access database must be open. That's no problem for me. But must the Access database be open when I insert records or otherwise update the referentially joined tables? If so, does an ADO connection string qualify as an "open" database?
I can execute my code in a manner that will update the parent table before the dependent tables and it seems that this shouldn't cause any errors due to the referential integrity. Is there anything else that I should know about manipulating referentially joined Access tables with ADO from an external program?
Thanks
AZ
