Installation problem - can't access DAO
Jana Hayes
I just upgraded my operating system from Windows 95 to NT4 and when I
installed Office under NT4 I have been unable to execute Access. When I
attempt to execute the program I get the message "Can't access the data
access object (DAO) and therefore can't continue". The suggested solution
is to reinstall Access, which I did, but I have the same problem. What do I
need to know about running Access under NT4?
Jana Hayes
Steve Thompson
Hi Jana,
The following KB article discusses this known issue - In addition,
download the patch for Access 95 running under Win NT 4.0.
http://www.microsoft.com/accessdev/DefOff.htm
You'll find it under free software.
PRB: Microsoft Access Can't Start the Data Access Object
PSS ID Number: Q141294
Article last modified on 08-27-1996
PSS database name: ACCESS
7.00
WINDOWS
---------------------------------------------------------------------
The information in this article applies to:
- Microsoft Access version 7.0
---------------------------------------------------------------------
SYMPTOMS
========
Novice: Requires knowledge of the user interface on single-user
computers.
When you start Microsoft Access for Windows 95 version 7.0, you may
receive
the following error message:
Microsoft Access can't start the data access object (DAO) and so
it can't continue.
You may also receive the following error message:
A system error occurred, or there isn't enough free memory to start
Microsoft Access. Close unneeded programs and try again.
CAUSE
=====
You have mismatched dynamic-link library (.dll) files for the versions
of
Microsoft Office and Microsoft Access installed on your computer.
RESOLUTION
==========
To resolve the mismatched .dll files, follow these steps:
1. Uninstall Microsoft Access 7.0. To do so, following these steps:
a. Click the Start button, point to Settings, and then click
Control
Panel.
b. In Control Panel, double-click Add/Remove Programs.
c. In the Add/Remove Programs Properties dialog box, click to
select
Microsoft Access 7.0, and then click Add/Remove.
d. Follow the instructions to remove all of Microsoft Access 7.0.
2. Start Windows Explorer.
3. Verify that the following files have been removed from your
computer:
Folder Location File Name
---------------------------------------------------------------
\Program Files\Common Files\Microsoft Shared\DAO DAO3032.DLL
\Windows\System MSJETSQL.TLB
\Windows\System MSJINT32.DLL
\Windows\System MSJT3032.DLL
\Windows\System MSJTER32.DLL
\Windows\System MSRD2X32.DLL
\Windows\System MSWNG300.DLL
\Windows\System VAEN232.DLL
\Windows\System VBA232.DLL
\Windows\System VBAJET32.DLL
\Windows\System VBAR2232.DLL
\Windows\System VEN2232.OLB
NOTE: If any of these files have not been removed, you should
delete
them from your computer.
4. Reinstall Microsoft Access 7.0. To do so, follow these steps:
a. Click the Start button, point to Settings, and then click
Control
Panel.
b. In Control Panel, double-click Add/Remove Programs.
c. In the Add/Remove Programs Properties dialog box, click Install.
d. Follow the instructions to install Microsoft Access 7.0 on your
computer.
5. Start Microsoft Access 7.0. If you again receive the error message
listed in the "Symptoms" section, reset the Windows Registry
settings
for Microsoft Access 7.0. To do so, follow these steps:
a. In Windows 95, click the Start button, and then click Run. (Or
in
Windows NT 3.51, click Run on the File menu in Program Manager
or
File Manager.)
b. Type a command to run the Microsoft Access Setup program using
the /y switch, for example:
a:\setup /y
c. In the Installation Maintenance Program box, click Reinstall.
The
Setup program updates the Windows Registry for Microsoft Access
7.0.
d. When Setup is complete, again try to start Microsoft Access 7.0.
Additional reference words: 7.00 database wizards fail stop create
KBCategory: kbsetup kberrmsg
KBSubcategory: StpErr
=============================================================================
Copyright Microsoft Corporation 1996.
-- Steve Thompson
-- [Access MVP]
Zororaster the Prophet
On Mon, 13 Jan 1997 19:50:41 GMT, acce...@noemail.org (Steve
Thompson) wrote:
Steve thanks for the info
I was having the same problem
James H. Brooks
This post is from the setup / configuration group:
--------------------------------------------------------------
From: Michael W. Shrader <MShr...@ix.netcom.com>
Every time I have seen this error message about DAO being unable to start,
it has been because the dao3032.dll has not been correctly registered.
In NT, you can navigate the the folder containing dao3032.dll and run
regsvr32.exe dao3032.dll and it fixes it. I have seen this on about 5
different machines, each time after someone has tried to use the setup
program to re-install or re-do the installation of Access.
--
Michael W. Shrader
TechLore Solutions
Houston, TX
----------------------------------------------------------------
I personally received the error, and without having to reinstall Access was
able to fix it with the above method. Good Luck (ps: for me the error
started after installing Access97 to coexist with Access95 and Access2)
Luc Forand
Thanks for the advice. I had the same problem with Windows 95 and
Microsoft Office. I moved to the directory containing dao3032.dll and
then used RUN with regsvr32.exe dao3032.dll which successfully
registered the dll. ACCESS than started properly.
Steve Thompson
Hi James,
Thanks for posting this, I learn something new, every day <g>.
>This post is from the setup / configuration group:
>
>--------------------------------------------------------------
>From: Michael W. Shrader <MShr...@ix.netcom.com>
>
>Every time I have seen this error message about DAO being unable to start,
>it has been because the dao3032.dll has not been correctly registered.
<snip>
Steve