I have database in SQL 2000 and VBA code in Access 2003.

When I try to run 1 report in Access 2003 (which is front end for application) it is giving timeout expired error.

Report is fetching records from SQL 2000 through 1 query. If I will run this query in SQL server, it fetched all 5500 records in less than 30 secs.

OLE / DDE timeout is default (30 secs) in Access 2003
Refresh interval is default (60 secs) in Access 2003

Connection timeout is 60 secs in SQL 2000 database. It can not be set to 0 as many users access the application at a time and chances of server hangout are high.

Can anyone please help to resolve this issue?