Cannot download Access 2007 templates

[coneill2]

I'm having the same problem. Any updates on this issue would be greatly appreciated. It's happening on local and internet templates.

Thanks

-c

 

[Schaffer]

I also have same problem. Have reinstalled to no effect. Cannot open *.accdt files from temp locations.
Here's hoping.

 

[dusty]

Well i solved my templates problem... I ended up losing a crucial dll file
over the weekend and had to reload windows completely. I had been working
with Microsoft Access support team (Very Very helpful people - thanks Donald
M.) and started to make some headway. So i can not be of much help in solving
the problem from here on out. With all the testing and experimenting we did
it was narrowed down to something in the registry.

But i have one question for the users who are having this problem...
do you have a file named Q815021_WXP_SP2_ia64_ENU.exe on your system?
I performed a windows update around the time the template issue started and
this is one of the download/updates that was processed. According to MS this
file is the incorrect version for my operating system - but it downloaded
anyway. Just a thought that it may have corrupted the registry file enough to
affect Access.
I am interested in the responses on the above file.
Good luck
John

 

[macktodd]

Well i solved my templates problem... I ended up losing a crucial dll file
over the weekend and had to reload windows completely. I had been working
with Microsoft Access support team (Very Very helpful people - thanks Donald
M.) and started to make some headway. So i cannotbe of much help in solving
the problem from here on out. With all the testing and experimenting we did
it was narrowed down to something in the registry.

But i have one question for the users who are having this problem...
do you have a file named Q815021_WXP_SP2_ia64_ENU.exe on your system?
I performed a windows update around the time the template issue started and
this is one of the download/updates that was processed. According to MS this
file is  the incorrect version for my operating system - but it downloaded
anyway. Just a thought that it may have corrupted the registry file enoughto
affect Access.
I am interested in the responses on the above file.
Good luck
John





- Show quoted text -

I am having the same problem. I have uninstalled Office 07 and
reinstalled it and the problem is still there. I have another message
that comes up before the "Template...could not be instantiated."
error. SQL Distibuted management objects (SQL-DMO) must be on the
machine running Microsoft Office Access. From what I have read this
is associated with Office 2000. Something else I have discovered is
that this maybe associated with XP SP2. We had SP2 pushed out the
night before I started having this issue. I'm hoping for a solution.

 

[Jeff Conrad [MSFT]]

Please try the following steps *carefully* and report back what happens:

1. Click the Windows Start button, then click the Run option.
2. Enter CMD and click OK to open a command window.
3. Type CD "C:\Program Files\Common Files\System\ado"
4. Now type regsvr32 /u msado15.dll (wait for confirmation message, then
click OK)
5. Now type regsvr32 msado15.dll (wait for confirmation message, then
click OK)

Step 3 unregisters msado15.dll and step 4 re-registers it.

Can you instantiate the templates now?

--
Jeff Conrad - Access Junkie - MVP Alumni
SDET - XAS Services - Microsoft Corporation

Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
http://www.accessmvp.com/JConrad/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com

----------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.mspx
----------

MackTodd wrote in message:

I am having the same problem. I have uninstalled Office 07 and
reinstalled it and the problem is still there. I have another message
that comes up before the "Template...could not be instantiated."
error. SQL Distibuted management objects (SQL-DMO) must be on the
machine running Microsoft Office Access. From what I have read this
is associated with Office 2000. Something else I have discovered is
that this maybe associated with XP SP2. We had SP2 pushed out the
night before I started having this issue. I'm hoping for a solution.

 

[Betty Boop]

I am having the same problem, but it starts downloading the template - then I
get a status bar with a message "Please wait while Microsoft Office Access
prepares the template for use." It gets about 1/4 of th way and I get a
second message - "SQL Distributed Management Objects (SQL-DMO) must be on the
machine running Microsoft Office Access." I am running XP, and Access 2007.
I downloaded some in the past, but suddenly it will no longer work. I tried
the steps to unregister and re-register the .dll file, but that didn't do
anything. I would appreciate any help.

 

[Chris]

I am having the same problem with the templates not instantiating as well. I
tried this route and still could not get the templates to work.

This is my version:
Microsoft Office Access 2007 (12.0.4518.1014) MSO (12.0.4518.1014)
Part of Microsoft Office Enterprise 2007

My System Information:
OS Name Microsoft Windows XP Professional
Version 5.1.2600 Service Pack 2 Build 2600
OS Manufacturer Microsoft Corporation
System Manufacturer Gateway
System Model MX7527
System Type X86-based PC
Processor x86 Family 15 Model 36 Stepping 2 AuthenticAMD ~2586 Mhz
BIOS Version/Date Phoenix 66.08.00, 12/19/2005
SMBIOS Version 2.4
Windows Directory C:\WINDOWS
System Directory C:\WINDOWS\system32
Boot Device \Device\HarddiskVolume1
Locale United States
Hardware Abstraction Layer Version = "5.1.2600.2180
(xpsp_sp2_rtm.040803-2158)"
Time Zone Central Daylight Time
Total Physical Memory 1,536.00 MB
Available Physical Memory 894.11 MB
Total Virtual Memory 2.00 GB
Available Virtual Memory 1.96 GB
Page File Space 2.95 GB
Page File C:\pagefile.sys

 

[rsjenkins]

SQL-DMO error installing Access Templates

Hello everyone I'm new to this forum, for several months I have had the same problems mentioned in this thread. I have tried everything to fix it (short or uninstalling & reinstall XP and/or Office 2007, I'm not that adventurous) and finally today it works. I've been researching this on and off for the past couple of months and came across a posting in a different forum that works.


Here is a copy of that thread:

"OK, how to repair a copy of MDAC 2.8 on WinXP with SP2 installed

first, locate the mdac.inf file in c:\windows\inf right click and
install
when prompted for a location, point to
c:\windows\servicepackfiles\i386 then when promtpet for the XPcd,
either load the cd or point to c:\i386

hey presto, this reinstalls / repairs MDAC 2.8"

I followed the directions above and then it looked for a different file (handler.reg)and I repeated the process looking in the windows folder and finding the file at: C:\Windows\I386\HANDLER.RE_. I did not have to use the XP cd. I hope this helps, I know this has aggravated me for months and am glad it finally works.