[AccessD] Access 2000 - ADP - Open View very slowwwww...

1. Up the timeout value.
2. Replace the view with a sproc.

A.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Tom Adams
Sent: April 17, 2003 3:58 PM
To: accessd at databaseadvisors.com
Subject: [AccessD] Access 2000 - ADP - Open View very slowwwww...


Against Sql Server 7 with latest service packs running on an NT4 machine
with the latest service packs.

I've got a view that is based on 2 other views and has a Case statement in
it.

It runs in about 5-10 seconds in Enterprise Manager but is timing
out/hanging up in Access.

Any ideas???