[AccessD] Linked Table to SQL Database

Hey guys,

 

I've got a linked table to a Sql Server database.  The table has
approximately 2,000,000 (yes..that is TWO MILLION...PLUS) records in it.
The data goes back at least 10 years.  I only need the data for, at
most, this year onward.  Is there a way to limit the link, to only pull
out data older than 01/01/06?  I am sure that Access will really chug,
trying to go through the 2,000,000 records (if a query will even be able
to handle it.)

 

Thanks,

 

Keith E. Williamson | Assist. Controller| kwilliamson at rtkl.com

RTKL Associates Inc. | 901 South Bond Street | Baltimore, Maryland
21231-3305

410-537-6098 direct | 410-276-2136 fax | www.rtkl.com
<http://www.rtkl.com/>