I created a link between my Access database and an ODBC database. The wizard created a new table in Access based on the table in the ODBC database I wanted to import. So anytime that table in the ODBC database is modified, the new table in my Access database will similarly be updated, correct?
But I need a table I created in Access to be also be automatically updated anytime someone enters information into the ODBC database - not just the table that was imported. How can I do that? How can I automatically copy tables from the ODBC table into one of my own Access tables?