Using an ODBC connection in Access get retrieve data from DB2

530 views Asked by At

Using Access 2010, I have set up an ODBC link to my organizations DB2 Database. From this database, I'm getting several tables, one of which houses over 100k records, on any given day, there may be 10 records added. I'm trying to find a way to restrict the data pool from this one table to just new records. Does anybody know of a good starting point for this?

1

There are 1 answers

0
Barry On

Have the DBA create a view that contains only the records you are interested in, then attach that just like a table. If you do a filter on the Access side of the equation, you will still be pulling the entire table down over the wire.