rusty.hammond at cpiqpc.com
rusty.hammond at cpiqpc.com
Tue Nov 28 15:22:00 CST 2006
Keith, Create a view on the SQL server that limits your records, then create the link in Access to that view. If you don't have the rights to the sql server to create the view, you can create a pass-through query in Access and limit your records via a SQL statement in the pass-through query. A limitation of a pass-through query is the data returned is read-only, which may may not work for your needs. HTH, Rusty -----Original Message----- From: Keith Williamson [mailto:Kwilliamson at rtkl.com] Sent: Tuesday, November 28, 2006 2:44 PM To: Access Developers discussion and problem solving Subject: [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/> -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com ********************************************************************** WARNING: All e-mail sent to and from this address will be received, scanned or otherwise recorded by the CPI Qualified Plan Consultants, Inc. corporate e-mail system and is subject to archival, monitoring or review by, and/or disclosure to, someone other than the recipient. **********************************************************************