How setup/install what components for using DAO.DBEngine.35 in Outlook script?
Doug Schaffer
The following line of code sets up a database object that can subsequently
be used to open a Access database connection, then a table, then read from
or write to the database.
Set dbe = item.Application.CreateObject("DAO.DBEngine.35")
I *think* this requires installation of DAO, which I've gotten from the DAO
REDIST of the VC++5.0.
After publishing this form and granting others access, roughly half of the
machines trying to access this form have been unsuccessful (even after
installing DAO). The error seen is ***"The operation failed due to a
registry or installation problem. Restart Outlook and try again. If the
problem persists, please reinstall."***
My hunch is that some VERSIONS of Outlook 97 work with this and some don't.
Otherwise, I'm missing something else that needs to be installed.
Versions:
DAO:
- 3.50.3602.0
- 3.000.2225 haven't tried to see if it makes a difference.
Outlook:
- 97 (8.01?)
- 97 SR-1
- 8.02.4212
- 8.03.4419
OS:
- Windows 95
- NT 3.51
- NT 4.0
It HAS worked on some 97 8.01 versions, but not others, all using DAO 3.5.
I developed on NT4.0, with Outlook 97 (8.01) and DAO 3.50.3602
Anyone come across this? Have any ideas on where I should look for a
solution?
Thanks!
Dug.
-----
Doug Schaffer
Quality Assistance Alchemist
Merak Projects
(403) 294-4300
do...@merak.com
Georg Schütz
I believe you've found the solution when writing that it works on all
machines with DAO 3.5xxx.
You should check this. Here's some sample code testing for opening errors on
creating the DAO Access.
'Referencing the Database-Engine
Set dbe = Item.Application.CreateObject("DAO.DBEngine.35")
'Checking for Errors
If Err.Number <> 0 Then
'Something did not work when setting the referenc to the DAO-Engine
'Err.Description tells you what happened
MsgBox Err.Description
Exit Sub
End If
Doug Schaffer schrieb in Nachricht <01bd05b4$9bfa82a0$090b0b0a@tyr>...
>
>After publishing this form and granting others access, roughly half of the
>machines trying to access this form have been unsuccessful (even after
>installing DAO). The error seen is ***"The operation failed due to a
>registry or installation problem. Restart Outlook and try again. If the
>problem persists, please reinstall."***