[AccessD] Question on Reference (DAO)

Do I reference them via code, or on each PC that runs the program? Or,
does it follow through after I set the reference while programming it?

>>> tom.bolton at donnslaw.co.uk 2/10/2005 3:58 AM >>>
Hear hear!

I've found this too - not having used DAO for years I shied away from
it
when returning to an Access project but it's noticeably quicker when
using
it for native Access objects.  Access was after all designed around
DAO/Jet.

I can't stress enough what Charlotte said: if you use a mixture of DAO
and
ADO, REFERENCE THEM EXPLICITLY!  (ADODB.Recordset, DAO.Database etc.)
You'll
be in a whole world of pain otherwise.

Cheers
Tom


-----Original Message-----
From: Bobby Heid [mailto:bheid at appdevgrp.com] 
Sent: 09 February 2005 19:27
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] Question on Reference (DAO)

It is my understanding that when accessing native Access databases,
that DAO
is the best performer.  If you will be accessing SQL Server or other
OLE
databases, use ADO.

Bobby

-----Original Message-----
From: accessd-bounces at databaseadvisors.com 
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Clark
Sent: Wednesday, February 09, 2005 1:51 PM
To: accessd at databaseadvisors.com 
Subject: [AccessD] Question on Reference (DAO)


I am working on a new program in A2K. Most of my older existing stuff
is
A97, and I just used some old code which had a problem. Basically, I
took
some code I was using, from an A97 db, to add items to a combo on
NotInList...I think the code was originally written by Dev Ashish. I
got a
"reference" error, so I went into the references and added Microsoft
DAO 3.6
object library, and it is working now.

My question is this; is this alright, or should I have adapted the code
to
fit 2K? Is there any penalty that I risk (i.e. speed, etc.) by keeping
it
this way?

Thanks, 

John W Clark
-- 
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