Well, thats what I thought too, to be honest, but a more experienced VBA
developer than me said the errors were due to this difference between DAO
and ADO.
I will try using ADO syntax and see if that works.
Thanks for all your input Andy
Will
-----Original Message-----
From: Andy Ewings [mailto:[EMAIL PROTECTED]]
Sent: 26 April 2001 15:15
To: CF-Talk
Subject: RE: slightly OT ADO vs DAO
If you are using VBA you should be able to choose which connection method
you use without any problem. As far as I can remember the code in the
module/class you are creating is separate from the mdb.....I'm not sure what
you mean when you say "in an ADO database". The database is just a database
- ADO is purely used as a method of interogating it. As I said earlier -
it's been a while since I used Access/VBA so may be way off!
------------------------------------------------------------------
Andrew Ewings
Project Manager
Thoughtbubble Ltd
http://www.thoughtbubble.net
------------------------------------------------------------------
United Kingdom
http://www.thoughtbubble.co.uk/
Tel: +44 (0) 20 7387 8890
------------------------------------------------------------------
New Zealand
http://www.thoughtbubble.co.nz/
Tel: +64 (0) 9 488 9131
------------------------------------------------------------------
The information in this email and in any attachments is confidential and
intended solely for the attention and use of the named addressee(s). Any
views or opinions presented are solely those of the author and do not
necessarily represent those of Thoughtbubble. This information may be
subject to legal, professional or other privilege and further distribution
of it is strictly prohibited without our authority. If you are not the
intended recipient, you are not authorised to disclose, copy, distribute, or
retain this message. Please notify us on +44 (0)207 387 8890.
-----Original Message-----
From: Will Swain [mailto:[EMAIL PROTECTED]]
Sent: 26 April 2001 15:10
To: CF-Talk
Subject: RE: slightly OT ADO vs DAO
Cheers Andy,
Its just I'm writing some VBA and gettings errors which I think are caused
by using DAO syntax in a ADO database, but that doesn't make too much sense
to me??
Cheers
Will
-----Original Message-----
From: Andy Ewings [mailto:[EMAIL PROTECTED]]
Sent: 26 April 2001 14:41
To: CF-Talk
Subject: RE: slightly OT ADO vs DAO
Yeh I think so. My use of DAO/ADO/RDO was through VB. Just used each to
create connection and query objects and run them against the db. I'm not
sure if you can choose which you want to use directly in Access although I
haven't used Access for a While and things may have changed in 2000!)
------------------------------------------------------------------
Andrew Ewings
Project Manager
Thoughtbubble Ltd
http://www.thoughtbubble.net
------------------------------------------------------------------
United Kingdom
http://www.thoughtbubble.co.uk/
Tel: +44 (0) 20 7387 8890
------------------------------------------------------------------
New Zealand
http://www.thoughtbubble.co.nz/
Tel: +64 (0) 9 488 9131
------------------------------------------------------------------
The information in this email and in any attachments is confidential and
intended solely for the attention and use of the named addressee(s). Any
views or opinions presented are solely those of the author and do not
necessarily represent those of Thoughtbubble. This information may be
subject to legal, professional or other privilege and further distribution
of it is strictly prohibited without our authority. If you are not the
intended recipient, you are not authorised to disclose, copy, distribute, or
retain this message. Please notify us on +44 (0)207 387 8890.
-----Original Message-----
From: Will Swain [mailto:[EMAIL PROTECTED]]
Sent: 26 April 2001 14:30
To: CF-Talk
Subject: RE: slightly OT ADO vs DAO
Thats how I saw it too.
As I'm new to this side of things, can you tell me, is it possible to use
both in an Access DB?
Cheers
Will
-----Original Message-----
From: Andy Ewings [mailto:[EMAIL PROTECTED]]
Sent: 26 April 2001 11:03
To: CF-Talk
Subject: RE: slightly OT ADO vs DAO
Nick has got a point that there is no guarantee of support for DAO (or RDO
come to that) but I can't see MS dropping uspport for something that ties in
so closely with a db that is so widely used
------------------------------------------------------------------
Andrew Ewings
Project Manager
Thoughtbubble Ltd
http://www.thoughtbubble.net
------------------------------------------------------------------
United Kingdom
http://www.thoughtbubble.co.uk/
Tel: +44 (0) 20 7387 8890
------------------------------------------------------------------
New Zealand
http://www.thoughtbubble.co.nz/
Tel: +64 (0) 9 488 9131
------------------------------------------------------------------
The information in this email and in any attachments is confidential and
intended solely for the attention and use of the named addressee(s). Any
views or opinions presented are solely those of the author and do not
necessarily represent those of Thoughtbubble. This information may be
subject to legal, professional or other privilege and further distribution
of it is strictly prohibited without our authority. If you are not the
intended recipient, you are not authorised to disclose, copy, distribute, or
retain this message. Please notify us on +44 (0)207 387 8890.
-----Original Message-----
From: DeVoil, Nick [mailto:[EMAIL PROTECTED]]
Sent: 26 April 2001 10:58
To: CF-Talk
Subject: RE: slightly OT ADO vs DAO
DAO is a dead-end. ADO is more future-proof.
Nick
-----Original Message-----
From: Will Swain [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 26, 2001 10:51 AM
To: CF-Talk
Subject: slightly OT ADO vs DAO
Hi all,
I know this is slightly OT, but I wanted to get peoples opinions about ADO
vs DAO in ACCESS2000. It's not something I'd looked at before to be honest,
so was looking for general feedback, info on each etc,
TIA
Will
**********************************************************************
Information in this email is confidential and may be privileged.
It is intended for the addressee only. If you have received it in error,
please notify the sender immediately and delete it from your system.
You should not otherwise copy it, retransmit it or use or disclose its
contents to anyone.
Thank you for your co-operation.
**********************************************************************
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
