Error when converting from MS Access 2003 to Access 2007

25 Nov 2007 6:57 PM

Dale

Not sure if this is an Access 2007 problem or if it's a Windows Vista problem.

When trying to open my Access 2003 database using Access 2007 and Windows
Vista, I get the following error message:

"Your Microsoft Office Access database or project contains a missing or
broken reference to the file 'srchui.dll' version 1.0. To insure that your
database or project works properly, you must fix this reference."

Any ideas or suggestions on what is causing this or how to fix?

Thanks,
Dale

25 Nov 2007 9:27 PM

Tony Toews [MVP]

Dale <D***@discussions.microsoft.com> wrote:

>Not sure if this is an Access 2007 problem or if it's a Windows Vista problem.
>
>When trying to open my Access 2003 database using Access 2007 and Windows
>Vista, I get the following error message:
>
> "Your Microsoft Office Access database or project contains a missing or
>broken reference to the file 'srchui.dll' version 1.0. To insure that your
>database or project works properly, you must fix this reference."

Chances are you don't need that DLL.

Write down the path and name of the extra ones (or put the following
code in a module and execute the code), delete from the references
list and Compile and Save All.   Keep any necessary references and
ensure they are distributed to the target system.

Dim ref As Reference

    For Each ref In Access.References
        Debug.Print ref.Name & " " & ref.FullPath & " " & ref.Major &
"." & ref.Minor
    Next ref

Tony

--
Tony Toews, Microsoft Access MVP
   Please respond only in the newsgroups so that others can
read the entire thread of messages.
   Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
   Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/