[AccessD] ADPs

Jim Dettman jimdettman at verizon.net
Wed Jul 7 12:25:30 CDT 2010


 ADP's still exist in 2003 and 2007.  Not sure about 2010, but I believe
they are on their way out.

 But talking to SQL Server with ODBC is still doable in any version, which
is sounds like what your doing, but I'm not sure.

Jim.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Wednesday, July 07, 2010 1:10 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] ADPs

Have ADPs been deprecated?

I am trying to use an Access FE and a SQL Server BE (Office 2003) and the
results are less than 
stellar, and I don't know why.  I want to be able to use SQL Server as the
BE but when running SQL 
Server on my dev laptop, my billing FE talking to SQL Server billing BE the
results just ... suck! 
I get times when it takes 30 seconds for as form to open.

I mostly use ODBC to talk driectly to tables but I have created views and
linked to those views. 
Even there though AFAICT  Access used ODBC.  This just doesn't seem correct,
SOMETHING is off and 
until I can actually use SQL Server to an Access FE myself I can hardly
recommend the experience to 
a client.  Nobody (including ME!) wants a 30 second form opening experience.

Any ideas of what to try?

-- 
John W. Colby
www.ColbyConsulting.com
-- 
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