By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,947 Members | 1,505 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,947 IT Pros & Developers. It's quick & easy.

Help on DAO in ACC2000

P: n/a
Recently I have changed from Acc97 to Acc2000 (I had to supply some data
entry tools for field data collection for users still using Acc97).
Among lot of other complications coming with Acc2000 (compared with very
reliable acc97) I have got problem with Help: In access 2000 all topics
with DAO are listed in index but otherwise not available, so I am using
two PCs when developing something, to have advantage of ACC97 help,
where all these topics are available.
Could anybody give me a hint, what could be a reason for this. In my
organization all the installations are being done by IT assistants, one
who assists me said this is common problem in all our department, I
myself have checked the installation CD - no traces of ADO help files.
--
V.Moltchanov

Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Yes, the help in A2000 really needs help. :-)

One workaround is to create a desktop shortcut directly to the DAO help
file. Search for DAO360.chm.
Other issues you may need to handle in changing to A2000:

1. Consider keeping your A97 as well as A2000. You can do that with a custom
install of Office 2000. If you have any difficulty getting them to co-exist,
see michka's article at:
http://www.trigeminal.com/usenet/usenet019.asp?1033

2. If a database will not convert, use A97 to decompile it first. While
Access is not running, enter this at the prompt. It's one line, and include
the quotes:
"c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
"c:\MyPath\MyDatabase.mdb"

3. If you use ActiveX controls (such as calendar), the version will probably
break when converted. Fix it through References on the Tools menu (from a
code window).

4. By default, A2000 and 2002 do not include a reference the DAO library, so
you need to set up a reference to Microsoft DAO 3.6. More info. on
references:
http://allenbrowne.com/ser-38.html

5. A2000/2002 do include a reference to the ADO library, which duplicates
objects such as Recordset, Field, Property. Either remove the ADO reference,
or explicitly disambiguate everywhere in your application, e.g.:
Dim rs As DAO.Recordset

6. The "Name AutoCorrect" has myriads of bugs and performance problems.
Turn it off immediately you create any A2000 database. More info:
http://allenbrowne.com/bug-03.html

7. There are new properties that give performance problems (such as
SubDataSheetName for tables), and some existing properties have had their
defaults changed in a way that could compromise your validation code (e.g.
AllowZeroLength for code). More info:
http://allenbrowne.com/bug-09.html

8. There are serious problems with some of the new features in JET 4, such
as the Decimal data type. More info:
http://allenbrowne.com/bug-08.html

9. Access 2000/2 is incapable of saving just the object you are changing
like A97 does. That means concurrency problems (2 people cannot work in
different objects in the same mdb at once), and it takes longer to save if
the mdb has many objects.

10. Instead of the integrated development environment in A97, A2000 and
later have a version of Visual Basic cobbled together with the main Access
window. That's handy if you with with dual monitors, but does cause other
problems from minor annoyances with way the windows behave through to Access
getting completely confused about what goes with what if you have different
versions of Access open at the same time, thereby corrupting the database.

11. It is absolutely essential to have the service packs for A2000/2. The
bugs are so many and so drastic that simply importing code from A97 and
closing your database is enough to corrupt it if you do not have the service
packs!!! Details:
http://support.microsoft.com/?id=304548

12. Many of the known bugs in A97 have not been fixed. Hundreds more were
introduced in A2000, and many of those remain unfixed in A2003. In our
experience, you can expect to waste time with a couple of new bugs you have
not come across before in every mdb you develop. Some of these are listed
here:
http://members.iinet.net.au/~allenbr...ips.html#flaws

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Vladislav Moltchanov" <vl******************@ktl.fi> wrote in message
news:cc**********@oxygen.ktl.fi...
Recently I have changed from Acc97 to Acc2000 (I had to supply some data
entry tools for field data collection for users still using Acc97).
Among lot of other complications coming with Acc2000 (compared with very
reliable acc97) I have got problem with Help: In access 2000 all topics
with DAO are listed in index but otherwise not available, so I am using
two PCs when developing something, to have advantage of ACC97 help,
where all these topics are available.
Could anybody give me a hint, what could be a reason for this. In my
organization all the installations are being done by IT assistants, one
who assists me said this is common problem in all our department, I
myself have checked the installation CD - no traces of ADO help files.
--
V.Moltchanov

Nov 13 '05 #2

P: n/a

Thank you very much, Allen, for your hints.
I have detected already myself some of the problems, compared with those
your list is a kind of Encyclopaedia. Now I will go through it keeping
in mind my priorities.V.Moltchanov

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.