compatui.dll version 1.0 is missing

Question

Hello,

I have a data base in Access written for Access 2003. I tried to access it through Access 2007 and it gives me that that compatui.dll version 1.0 is missing, and then it shows me (and error maybe) in the following code (and the error line is indicated):

[code]

Private Sub cmbUsername_AfterUpdate()

' Find the record that matches the control.

Dim rs As Object

Set rs = Me.Recordset.Clone

[HERE IN THIS LINE >>>>]rs.FindFirst "[Id] = " & Str(Me![cmbUsername])

Me.Bookmark = rs.Bookmark

If IsNull(Me.Password) Or Me.Password < " " Then

Me.txtPwd.Enabled = False

Else

Me.txtPwd.Enabled = True

End If

End Sub

[/code]

So I have few questions:

(1) What does compatui.dll does? Is it a library for string handling? Or is it a library for interface as the name suggests?

(2) Is there a way to fix the code so that it becomes compatible with all other Access versions?

(3) If now, how do I fix that on Access 2007 with minimum installations?

Thanks for your help in advance.

Answer 1

If you verify your Reference Libraries (Tools->References), are any of them marked as MISSING?  If so, then you need to update your references or remove any that are not actually required.

Also, does you code compile?

I moved the file compatui.dll from Windows XP System32 folder to my Windows 8 System32 folder and it worked fine.

It only compiled the username/password window, but nothing else.

Just to test what you said, I removed the file and opened the Access file. I checked Tools, but I cannot select References. It is dim.

I still don't know what the reference does. I want to change the code so that the user does not have to install that file. :/

Answer 2

If you verify your Reference Libraries (Tools->References), are any of them marked as MISSING?  If so, then you need to update your references or remove any that are not actually required.

Also, does you code compile?