[AccessD] Linked Table to SQL Database

Keith Williamson Kwilliamson at RTKL.com
Tue Nov 28 15:34:10 CST 2006


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




More information about the AccessD mailing list