MS Access performance enhancement?

From: Chieko Kuroda (anonymous_at_discussions.microsoft.com)
Date: 03/24/04 

Date: Wed, 24 Mar 2004 07:06:08 -0800

Hello,
I'm not sure if this is the right newsgroup to post this question to or not.
I have a backend sql server database with three tables. I decided to use access as the front end. and created some queries with self joins to one table that has 5000 records in it and made some aggregate queries. When I run the queries on the sql query analyzer they execute with in seconds, but when I run the same query within Access they take 1 - 2 minutes to execute. Here's one query example:

SELECT p2.DemoID, p2.UNITNUM, p2.DC_Date, (select min(Admit_date) from dbo_Picuadmissions p1
Where p1.demoID = p2.demoid
and p1.admit_Date > p2.DC_Date) AS NextBegin
FROM dbo_Picuadmissions AS p2
WHERE (((p2.DC_Date)>#1/1/2003#))
ORDER BY p2.UNITNUM, p2.DemoID, p2.DC_Date;

Can anyone suggest some performance enhancements?
Or should I use Access Data Project?
Chieko