Table A is a table internal to Access 2007.
Table B is a linked table in Access 2007 to SQL Server 2012.
In Access VBA, have a module that does the following steps:
1. Call a DTSX that updates Table B
2. VBA code calls an update query (DoCmd.OpenQuery) that is supposed to update Table A's flag with Table B's flag.
Issue: the update query is using Table B's values prior to the DTSX update.
If I rerun the update query, I get the correct values.
I need to have Table B values to be the most current values before update.
Any help is appreciated.