I have written a quick and dirty function (see below) that verifies whether a given table exists or not. (the function is used by another very important procedure).
Good, this function works really fine on my home computer with Access 2002.
Now when I try to run the database on the computer at work (MS Access 2002 as well) a message pops up asking me to uncheck the reference to ADO Ext. Ver 2.7., because the library doesn´t seem to exist, although a simple search indicates that the file msadox.dll is there in the correct location.
How do I reference it though? I have tried to gently guide Access to the file msadox.dll several times, but it hasn´t worked...
Thanks in advance for hints and suggestions.
Quote:
Function tabvorh(tabname As String) As Boolean
Dim cat As New ADOX.Catalog
Dim tbl As ADOX.Table
Set cat.ActiveConnection = CurrentProject.Connection
tabvorh = False
For Each tbl In cat.Tables
If tbl.name = tabname Then
tabvorh = True
Exit For
End If
Next
Set cat = Nothing
End Function