[AccessD] Updateable Access Forms Bound to ADO Recordsets

Hi Dan:

I have done most of my Access work with direct ADO-OLE connecting to MS SQL
and Oracle databases since 1997. Performance increases are on another
magnitude. 

Some jobs that would take an hour could be reduced to seconds by not using
pass-through queries, ODBC drivers... and never using DAO MDB databases
except to stash temporary local data.

Note; that the MS article is describing an ADP type database and as far as I
know that technology has a tenuous future... though my knowledge on its
survival may not be current or complete and some other member may have
further comment.

HTH
Jim

PS I have rarely used bound forms     

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters
Sent: Friday, December 22, 2006 7:31 PM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Updateable Access Forms Bound to ADO Recordsets

MS has published a seven page KB article on using updateable Access forms
bound to an ADO recordset.  This uses a specific OLEDB Provider with A2002
or A2003.  The article discusses requirements for SQL Server, Oracle, and
ODBC databases.

Has anyone tried this or have any thoughts on what the performance might be
on a WAN?

http://support.microsoft.com/kb/281998


Thanks!
Dan Waters


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com