I'm using the Lotus NotesSQL ODBC driver for an app I'm writing in
Access. I'm doing a simple select query from a Notes View and it takes
15 minutes to run! I tried doing it with 1 day's worth of data which
should return about 5-10 rows and it still took 15 minutes. Here's my
query:

SELECT "AM" AS Classification, By_Request.[_85],
By_Request.Assignee_List, By_Request.DateClosed, By_Request.RecID,
By_Request.STATUS, By_Request.[_23], By_Request.[_76], By_Request.[_84]
FROM By_Request
WHERE (((By_Request.DateClosed)="2006-08-01"));


When I run it, it prompts me for my password which I supply and it does
run correctly, it just takes too damn long!! Any help is greatly
appreciated!

Shelley