Access 2010 Data Macros
Posted on 2014-04-22
Hopefully just a quick question with a quick answer. I have searched the interweb and cannot find a direct answer.
I am trying to determine if the CreateRecord Data Action when used in any of the After Insert/Update/Delete Data Macros can write to a table that is not in the same database.
I am guessing not because I have tried to a linked table in both Access 2010 and SQL Server and the Data Macros do nothing. If the table is local to the database then all is fine.
None of the documentation I can find explicity states one way or another - just that "this data actions writes a record to the named table" (or words similar).
I am trying to have a central table that holds details of changes made in several databases (the created record would hold the DB Name, Tablename, and PK of the affected record). The changes log would hold records with unique id's (Autonum).
This way our occasionally connected apps would need to look at one DB and one table only when they are on the network to know which other databases/tables/records need looking at. This way we minimise the connections and data transfers.
If we cannot have a central table, we will have to hit every database every time because each DB will need to have its own changes log.