How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask jnlichen Your Own Question

jnlichen
jnlichen, IT Manager
Category: Microsoft Office
Satisfied Customers: 166
Experience:  15+ years supporting users, computers, & software.
39939051
Type Your Microsoft Office Question Here...
jnlichen is online now
A new question is answered every 9 seconds

error loading import wizard in access 2003 & 2007 - " error

This answer was rated:

error loading import wizard in access 2003 & 2007 - " error loading DLL -
am trying suggestions to REGISTER "Dao\Dao360.dll " - but dont have a DAO folder or such dll file - running windows 7 64 bit

Good morning. My name is XXXXX XXXXX I will assist you with this. We are going to go through a few processes.

1st. make sure your Windows update are current.

.

2nd. Go to a command prompt and type

sfc /SCANNOW

Let it run to completion.

.

3rd. From the command prompt run:

Regsvr32.exe "C:\Program Files\Common Files\Microsoft Shared\DAO\Dao360.dll"

.

4th. Retry your import.

.

If your import fails from here, install SQL Server Express 2008 (from MS site). This should repair and update ant MDAC/WDAC issues.

Let me know.

-John

jnlichen, IT Manager
Category: Microsoft Office
Satisfied Customers: 166
Experience: 15+ years supporting users, computers, & software.
jnlichen and 2 other Microsoft Office Specialists are ready to help you
Customer: replied 4 years ago.
Your Expert answered your Microsoft Office questionas my original email stated that my win 7 64bit does not appear to have a dao folder or dao360.dll file when I search manually via directories - however when I use SEARCH command it finds them in the 2 areas

I have unhidden files & folders in TOOLS FOLDER views etc

so for some reason windows is hiding the DAO folder ?? – is there another way to UNHIDE these folders ??

These folders are hidden as they are system folders. You do not want to unhide them. Step 2 from above will replace missing system dlls, and if it is necessary to install sql express, the folders will be updated with the latest version of files necessary to handle importing data.

.

Have you gone through the recommended steps as of yet?

Customer: replied 4 years ago.

I tried step 3 & system error cannont find path - I made a " DAO" folder & copied dao360.dll into it & reran step 3 & it registered successfully as per the copy in program(x86) \ado folder & was successful ..


I also installed SQL server 2008 R2 - & still getting the error ..


yesterday I uninstalled MS office 2007 & today I installed Office 2003 PRO & still got same error in ACCESS 2003 when trying to IMPORT an XCEL 2003 spreedsheet--


searching the Internet many times shows this is a very common problem & no sign of positive FIXES


 


cheers


 


bob

Bob, I will opt out and open your question up to other Experts. Good luck.
Hi, I’m a moderator for this topic. Your Professional has opted out and I wonder whether you’re still waiting for an answer. If you are, please let me know and I will do my best to find another Professional to assist you right away. If not, feel free to let me know and I will cancel this question for you. Thank you!
Customer: replied 4 years ago.

I think I will OPT out too - it looks like another microsoft blue !! - reading dozens of reviews of this problem on the internet shows theres no solution - its a wonder folk dont demand their money back after purchasing MS OFFICE !!-


anyway I'm still happy to cover ur costs for the time & effort given me - many thanks


 


cheers


 


bobmac

Customer: replied 4 years ago.

have solved the problem in Windows XP after uninstalling office 2007 & 2003 - reinstalled office 2003 & then the upgrade to office 2007 & registered those 2 files u recommended & alls well -


 


did the same in the windows 7 ultimate 64 bit & still the same error message - so obviously windows 7 64 Ultimate has a problem - any suggestions ??


 


cheers


 


bob

On the win 7, what happens if you just load o2k3?

Customer: replied 4 years ago.
what is o2k3 ??

Sorry, Office 2003.

Customer: replied 4 years ago.
when installing 2007 upgrade - most of the 2003 was replaced - only "MS office info path 2003 " & 2003 save settings & language remail on the menu options
Thank you for your patience, your business is very important to us, we are waiting on the Professional with the right expertise to come online. Feel free to let us know if you would like us to continue searching for a Professional or if you would like us to close your question. Thank you for your understanding!
Customer: replied 4 years ago.

I found this article & amended the line in my registry link "\0\win32 " - but no difference - did not load the " HEX " part of the article - did try but did not load/install into the registry div>
.
http://answers.microsoft.com/en-us/office/forum/office_2007-access/error-in-loading-dll-in-access-2007/99555025-b21c-4585-b74e-9d1db61a9d2a
.
I also tried ur suggestion about updating MDAC - but could'nt find a source that was strait forward -
what do u think ??

cheers

bob

Take everything after my name and copy into a text file. Rename the file with a .reg extension. Save it to your desktop. Right click and select merge or double click on it. From what I've read from your article, this may just work.

-John

[HKEY_CLASSES_ROOT\TypeLib\{00025E01-0000-0000-C000-000000000046}\5.0\0\win32]

@=hex(2):25,00,43,00,6f,00,6d,00,6d,00,6f,00,6e,00,50,00,72,00,6f,00,67,00,72, 00,61,00,6d,00,46,00,69,00,6c,00,65,00,73,00,25,00,5c,00,4d,00,69,00,63,00, 72,00,6f,00,73,00,6f,00,66,00,74,00,20,00,53,00,68,00,61,00,72,00,65,00,64, 00,5c,00,44,00,41,00,4f,00,5c,00,64,00,61,00,6f,00,33,00,36,00,30,00,2e,00, 64,00,6c,00,6c,00,00,00
This will import this key into the registry.
Customer: replied 4 years ago.

ebbe I'm stupid !!? - same as last night - error displays :-


Cannot import " bob.reg " - The specified file is not a registry script-


You can only import Binary files from within the registry editor..


 


bob

my bad. left the first line off: Just add the first line


Windows Registry Editor Version 5.00

[HKEY_CLASSES_ROOT\TypeLib\{00025E01-0000-0000-C000-000000000046}\5.0\0\win32]

@=hex(2):25,00,43,00,6f,00,6d,00,6d,00,6f,00,6e,00,50,00,72,00,6f,00,67,00,72, 00,61,00,6d,00,46,00,69,00,6c,00,65,00,73,00,25,00,5c,00,4d,00,69,00,63,00, 72,00,6f,00,73,00,6f,00,66,00,74,00,20,00,53,00,68,00,61,00,72,00,65,00,64, 00,5c,00,44,00,41,00,4f,00,5c,00,64,00,61,00,6f,00,33,00,36,00,30,00,2e,00, 64,00,6c,00,6c,00,00,00
Customer: replied 4 years ago.

when u say 1st line - if u mean the line beginning [HKEY --- ; it came up with same error


 


 

This line:


Windows Registry Editor Version 5.00

Customer: replied 4 years ago.

u r not going to believe it !! - IT WORKS !!!


I was all set to chuck WIN 7 out


 


many thanks again for ur help - my next step was to install a suggested JET fix - but will leave it -


 


cheers


 


bob

Glad it worked. Cheers Wink
Customer: replied 4 years ago.
I tried to load my answer into your WEB REPLY TO EXPERT but did not accept my text :-
http://answers.microsoft.com/en-us/office/forum/office_2007-access/error-in-loading-dll-in-access-2007/99555025-b21c-4585-b74e-9d1db61a9d2a
.
I found this article & amended the line in my registry link "\0\win32 " - but no difference -& did not load the " HEX " part of the article –& did try but did not load/install into the registry div>
.
http://answers.microsoft.com/en-us/office/forum/office_2007-access/error-in-loading-dll-in-access-2007/99555025-b21c-4585-b74e-9d1db61a9d2a
.
I also tried ur suggestion about updating MDAC - but could'nt find a source that was strait forward -
what do u think ??
cheers

bob
Bob, was this a re-post? I thought we had you fixed last night.
Customer: replied 4 years ago.

no new post - yes we have fixed the problem - many thanks - I have learned a few things !!


 


cheers


 


 


bob