This may be an Access 2003 question rather than a DB2 question but I hope that someone may know the answer.

We're moving from Access 2000 to 2003. One of our Access applications serves as a front end: one of the tables in ACCESS is a linked table to the DB2 database via ODBC.

If I try a search in the form, I have to wait half a minute for the result, I am connected to the DB2 server via LAN. People who are connected to our DB2 server via WAN have to wait 30 minutes or longer. It seems Access 2003 reads the whole table and performs the search on the client PC instead of letting DB2 do the search on the server. Access 2000 was able to use the indexes defined on the table in DB2 (search took 1 or 2 seconds). How can I convince Access 2003 to use DB2's indexes too ?

Any suggestions ?

many products pull the complete table down and apply the predicate locally..
I don't see a way around this .. (use other tools../ application..that will do what you request and don't live there own lives..)

Have you tried using a passthru query instead ?

I'm not an Access guru. The current solution is a temporary one, until we find the resources to analyse and program it from the ground up. The form was written by one of our end users and the linked DB2 table was a solution for the inability of Access to handle multiple concurrent users. Ripping this table out of Access and putting it in a multi user DB solved the problem, until Access 2003 came at the rescue.

How can you use a form with pass through? I think he then has to reprogram the whole form and with a totally different design.