MS ACCESS 2003 DAO ERROR 1706

I was working on a MS Access database today and got a DAO 1706 Error.  I've found a fix.... Keep reading to find out how!
I was working on one of my many Access databases today and got a strange error. It was a DAO 1706 error and thankfully a fellow tech guy, Phil, had the same problem a while back and posted the fix on his blog.

So I'm going to post it here in my blog and I'm also going to give Phil full credit and post a link to his site below just in case you would like to check it out. You just might some helpful information in there just like I did.

So here is the fix:

The final resolution turned out to be surprisingly simple. Access 2002 uses a DAO360.dll file for the DAO component. The resolution for this problem is to unregister the dll file and then re-register it.

Command to unregister the file:
regsvr32 /u "C:\Program Files\Common Files\Microsoft Shared\DAO\dao360.dll"

Command to register the file:
regsvr32 "C:\Program Files\Common Files\Microsoft Shared\DAO\dao360.dll"

That is all there is to it and your problem with be fixed.

Here is a link to Phil's Blog Project

Comments

There have been no comments made on this article. Why not be the first and add your own comment using the form below.

Leave a comment

Commenting is restricted to registered users only. Please register or login now to submit a comment.