What version of DAO does Access 2002/2003 have?

[tombsy]

Please can you tell me what version of DAO does access 2002/2003 use ?

Access 97/2000 can use DAO3.5 and DAO3.6
Can I compact a 2002/2003 db using DAO 3.6?
thanks in advance
regs Tombsy

[Mark D. Hill]

DAO is no longer being updated, or used as the default in Access, by
Microsoft. They have made the move to ADO, so to the best of my
knowledge, DAO 3.6 is the last you'll find.

Take a look at:

http://www.a1vbcode.com/vbtip.asp?ID=23

on how to use ADO (JRO actually). I really don't think you can use DAO on
a Jet engine beyond 3.x (Access 97). I'd test it a LOT before I'd try it
on a Jet 4 database that mattered.

On Fri, 19 Nov 2004, tombsy wrote:

Please can you tell me what version of DAO does access 2002/2003 use ?

Access 97/2000 can use DAO3.5 and DAO3.6
Can I compact a 2002/2003 db using DAO 3.6?
thanks in advance
regs Tombsy

[Tony Toews]

"tombsy" <ic*****@tiscali.co.uk> wrote:

Please can you tell me what version of DAO does access 2002/2003 use ?

Access 97/2000 can use DAO3.5 and DAO3.6
Can I compact a 2002/2003 db using DAO 3.6?

A97 uses DAO 3.5. A2000 and newer uses DAO 3.6.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

[Larry Linson]

"Mark D. Hill" <ma******@u.washington.edu> wrote

DAO is no longer being updated, or used
as the default in Access, by Microsoft. They
have made the move to ADO, so to the best
of my knowledge, DAO 3.6 is the last you'll
find.

The current advice from knowledgeable insiders at Microsoft is to use DAO
rather than ADO, as a general rule. Although Jet, of which DAO is the
"native language", is _officially_ "in maintenance mode", they have, in
fact, included some enhancements in Jet 4. SPs (of which there are eight or
nine -- I can't keep track!).

ADO does not give you a "headstart on the future" because its successor
ADO.NET is already available, and doesn't share the same object model as
"classic ADO".

Larry Linson
Microsoft Access MVP

[Tony Toews]

"Mark D. Hill" <ma******@u.washington.edu> wrote:

DAO is no longer being updated, or used as the default in Access, by
Microsoft.
A2003 now has the DAO reference above the ADO reference.
I really don't think you can use DAO on
a Jet engine beyond 3.x (Access 97). I'd test it a LOT before I'd try it
on a Jet 4 database that mattered.

Huh? DAO 3.6 works just fine on a Jet 4.0 database.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

[tombsy]

Many thanks to Larry and Tony

As I suspected...
DAO 3.6 is good for compacting all versions of Access from Access2 upwards.
This is good news for my utility app.

thanks for the indepth response

kind regs

Tombsy
"Tony Toews" <tt****@telusplanet.net> wrote in message
news:ed********************************@4ax.com...

"Mark D. Hill" <ma******@u.washington.edu> wrote:

DAO is no longer being updated, or used as the default in Access, by
Microsoft.

A2003 now has the DAO reference above the ADO reference.

I really don't think you can use DAO on
a Jet engine beyond 3.x (Access 97). I'd test it a LOT before I'd try it
on a Jet 4 database that mattered.

Huh? DAO 3.6 works just fine on a Jet 4.0 database.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

[Mark D. Hill]

On Sat, 20 Nov 2004, Tony Toews wrote:

"Mark D. Hill" <ma******@u.washington.edu> wrote:

DAO is no longer being updated, or used as the default in Access, by
Microsoft.
A2003 now has the DAO reference above the ADO reference.

I really don't think you can use DAO on
a Jet engine beyond 3.x (Access 97). I'd test it a LOT before I'd try it
on a Jet 4 database that mattered.

Huh? DAO 3.6 works just fine on a Jet 4.0 database.

That didn't come out the way I'd intended. I know you can use DAO with
Jet 4 - I support a lot of Access 2000 dbs that are running DAO code.

It would have been helpful if I had completed my thought: "...don't think
you can use DAO to *compact* a Jet engine beyond 3.x". But after testing,
I found you can... with a caveat. You cannot run CompactDatabase from
Access 97 (and older) on a Access 2000 (or newer) db.

Tony, if you know otherwise, I'd be interested in any documentation you could
point us to.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

[Tony Toews]

"Mark D. Hill" <ma******@u.washington.edu> wrote:

It would have been helpful if I had completed my thought: "...don't think
you can use DAO to *compact* a Jet engine beyond 3.x". But after testing,
I found you can... with a caveat. You cannot run CompactDatabase from
Access 97 (and older) on a Access 2000 (or newer) db.

Tony, if you know otherwise, I'd be interested in any documentation you could
point us to.

AFAIK you are correct. I suppose you could try referencing the MS DAO 3.6 library
but I'd be somewhat skeptical of this approach. <smile>

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm