Hi Mike,
Thank you for posting in the community.
From your description, I understand that when you executed the following
code from the immediate window:
-------------------------------------------------------------------------------------
?application.CurrentProject.Connection.ConnectionStrin
------------------------------------------------------------------------------------
you got the Run-time error '-2147024769 (8007007F)'. However, the
following code executes with no Automation Error
-------------------------------------------------
?application.CurrentProject.Nam
--------------------------------------------------
I'm not 100% sure if you are implementing mail merge in VBA code. If
possible, could you please specify how to reproduce this problem and can
you compile your code before execution?
Based on my experience, this problem seems to be caused some ADO
related DLL files are corrupt or not registered properly. I recommend you
download the Componnet Checker (CC) to check your MDAC version and
compare the version number of each MDAC DLL file to a list of the DLL files
that are shipped with each MDAC version to see if there is any mismatch on
the DLLs.
301202 HOW TO: Check for MDAC Version
http://support.microsoft.com/?id=301202
Additionally, it is recommended you download and apply the MDAC 2.7
SP1 Refresh via the following link:
Microsoft Data Access Components (MDAC) 2.7 Service Pack 1 Refresh
http://www.microsoft.com/downloads/details.aspx?FamilyID=9ad000f2-
cae7-493d-b0f3-ae36c570ade8&DisplayLang=en
Before apply this MDAC, please exit all the applications and stop all the
services (can set them Manual startup type) related with the data access
component. After upgrading to MDAC 2.7 SP1 Refresh, a machine reboot is
needed for component update.
If you have already applied MDAC 2.7 SP1 Refresh or later version on your
Windows XP SP1 machine, I suspect that MDAC upgrade is not complete
(with no machine reboot for instance) Please read the following KB to
diagnose Problems and reconfigure MDAC Installations:
307255 INFO: Component Checker: Diagnose Problems and Reconfigure
MDAC
http://support.microsoft.com/?id=307255
Please apply my suggestions above and let me know if this helps resolve
your problem. If the problem persists after apply MDAC 2.7 SP1 refresh, we
need to collect more information as asked in this message and appreciate
your assistance provided more detailed steps to reproduce the problem.
If there is anything I can do to assist you , please feel free to post it in the
group.
Best regards,
Billy Yao
Microsoft Online Support
