I know the title here is going to make some people think I've lost my mind before the thread even begins. Let me lay out the context.<BR><BR>I do some consulting work for my former employer because ...

I've just started using MS Access 2007 heavily the past few days (after not having touched it since 2000). <BR><BR>My issue is that I have written a query in SQL view that takes about 60 seconds to ...

If you are interested in the fastest performance, don't use Access as a front-end to a SQL Server database. While Access is relatively easy to learn and fast to develop in, its performance is poor ...