[AccessD] Table Linking in Access 2000

Did you include a warning that ADO tends to be slower in creating links
that DAO?  At least that's been my experience.  I only use ADO for this
in a situation where DAO is not being used at all.

Charlotte Foust

-----Original Message-----
From: Steve Goodhall [mailto:sgoodhall at comcast.net] 
Sent: Saturday, November 29, 2003 3:31 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] Table Linking in Access 2000


I know that some of you picked up my Access97 routines that dynamically
link to back-end tables because I get an occasional question.  I finally
got around to rewriting them for Access2000, that is to use ADO rather
than DAO to create the links.  I have posted a sample database and
documentation to my web site, www.goodhall.info/steve.  Click on "Useful
Software" on the left frame and download the first item.  Feel free to
use these subject to the specified conditions which mostly consist of
retaining the Copyright notices.  As usual, there is no warranty
expressed or implied.

Regards,

Steve Goodhall

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