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
7  3817 
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
"tombsy" <ic*****@tiscal i.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
"Mark D. Hill" <ma******@u.was hington.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
"Mark D. Hill" <ma******@u.was hington.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
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****@teluspl anet.net> wrote in message
news:ed******** *************** *********@4ax.c om... "Mark D. Hill" <ma******@u.was hington.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
On Sat, 20 Nov 2004, Tony Toews wrote: "Mark D. Hill" <ma******@u.was hington.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
"Mark D. Hill" <ma******@u.was hington.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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: asj |
last post by:
Can you guess what this is?
http://www.blueboard.com/phone/apache_sept_2003.gif
It's a history of the IIs "Titanic", which is being slowly and
painfully sunk by the open source Apache web server.
In September, Microsoft's IIs web server again continued to lose
marketshare dramatically to the open source Apache web server.
|
by: David Hare-Scott |
last post by:
From what I can glean from M$ propaganda the big thing for Access 2003
is XML. I cannot think right now why I would want to use XML with
Access unless I needed to exchange complex data remotely with foreign
platforms or systems - which I don't. I can see some of the reasons for
XML in other contexts but what is the value for Access?
Generally is Access 2003 a useful upgrade or is it just another
marketting ploy to get more $ from us...
|
by: DOG |
last post by:
I am (was) an Access programmer with 10 years experience - I have
taken a break from work for 2 years to pursue other interests. The
last version of Access I was using on a day to day basis was Access
97. I did spend a little time with Access 2000 but not very much.
What I want to know is: From a programmers point of view what are the
main changes I need to familiarise myself between Access 97 and the
current version?
|
by: Danny |
last post by:
I want to buy the latest version of ms access.
Will this version let me create an mdb that will work with a lesser version
such as 2000, I am having a problem going from 2002 to 2000. The mde will
not work.
Is there a place you recommend that has it for a decent price?
Thanks
|
by: Neil Ginsberg |
last post by:
Does anyone know if a new version of Access is due to come out anytime soon?
Thanks,
Neil
| | |
by: Br |
last post by:
We're using an Access2000 ADP with an SQL2000 back-end. Because SQL2000
was released after Access2000 you need to be running Access2000 SP1 (2
or 3) for it to work properly.
Is there an easy way for the ADP to determine programatically wether the
correct service pack is installed (or if they are using a newer version
such as 2002/2003)?
Ta.
|
by: ship |
last post by:
Hi
We need some advice: We are thinking of upgrading our Access database
from Access 2000 to Access 2004.
How stable is MS Office 2003? (particularly Access 2003).
We are just a small company and this is a big decision for us(!) It's
not just the money it's committing to an new version of Access!
|
by: Jozef |
last post by:
Hello,
I have an application that I have been deploying with the Office 2002 / XP
Developers Edition Package and Deployment wizard. The package that it
creates is 180 MB in size. I would like to use a third party packaging /
setup script instead to reduce the size of the package. I spoke with
someone in passing once that said he was able to reduce his package to about
a third of it's size by using another program to package it, but I...
|
by: jamcompany via AccessMonster.com |
last post by:
Hi ,
I'm wondering it there is a way to notify users of the need to use a
different version of Access (2003). I have an Access 2003 mde file that
can't be opened by Access 2000-2002 users. I would like to pop up a message
(instead of the Access error message that it does not recognize the format),
telling the user that they need to be running Access 2003.
A background note - I am developing in 2002/2003 format on a machine running...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| | |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
