[AccessD] Linked Table to SQL Database

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.
**********************************************************************



More information about the AccessD mailing list