I have a SQL DTS package that reads a text file and populates a table in sql. The DTS package runs every night at midnight. This SQL table is linked to an Access 97 table. If I open Access in the morning I can update all cascading tables in access manually.
Does anyone know a way to automatically update a Access 97 table? It would require opening access and running 1 or more queries after the DTS package in SQL runs.