rusty.hammond at cpiqpc.com
rusty.hammond at cpiqpc.com
Tue Nov 28 16:43:40 CST 2006
Arthur, Interesting approach. I've done some brief reading BOL and I can see where this could speed up a few applications I have here. Thanks! Rusty -----Original Message----- From: artful at rogers.com [mailto:artful at rogers.com] Sent: Tuesday, November 28, 2006 4:21 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Linked Table to SQL Database You can also employ a technique called horizontal partitioning, which will break the large table into two or more chunks that exist as several physical files. The advantage to this approach is that if and when you ever need to, you can address the whole table easily. Look in BOL for Horizontal Partitioning. Arthur ----- Original Message ---- From: Keith Williamson <Kwilliamson at rtkl.com> To: Access Developers discussion and problem solving <accessd at databaseadvisors.com> Sent: Tuesday, November 28, 2006 4:34:10 PM Subject: Re: [AccessD] Linked Table to SQL Database Okay. Thanks a lot!! Regards, 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 -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of rusty.hammond at cpiqpc.com Sent: Tuesday, November 28, 2006 4:22 PM To: accessd at databaseadvisors.com Subject: Re: [AccessD] Linked Table to SQL Database 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. ********************************************************************** -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.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. **********************************************************************