Object doesn't support property or method

[Jamy]

I have a database with a login form. After distributing the FE (incl. Access Runtime 2007 which is installed automatically) on 5 pc's everything was working, except for one PC. After clicking on the OK button in the login form it showed the error message: "Object doesn't support property or method". The PC is using XP prof SP3.



There used to be a trail version of Access 2007 installed on this PC, after i deleted it, it still didn't work. I've reinstalled the trail and used the original db on USB stick (the BE is on server). It still showed the same error.

I've checked the liberary (reference) settings and they were the same as on my pc, so this shouldn't be the problem.

On all the other PC's the code is working, so I thought there's no need to include the coding. (this should be correct).

You have any thoughts?

Thanks in advance!

[Guus2005]

You said you checked the reference settings. If on the XP computer office 2003 is installed prehaps a previous reference is needed. You might see MISSING in the reference list. Uncheck and scroll to the right version.

HTH

[Jamy]

Office 2007 is installed on the computer. I've checked, the versions of the references are all the same as i have them (computer on which the db was created).

You think there is anything besides the references what can interfere with the process?

[Guus2005]

What is the exact error message?

Try to locate the exact position only then you can pinpoint the problem.

Are you using a construction like this:

    Dim oFSO
    Set oFSO = CreateObject("Scripting.FileSystemObject")

This is an implicit object reference. You can create objects on the fly. It requires a substantial knowledge of the chosen object.

'Late binding:
    Dim oFSO_I As Object
    Set oFSO_I = CreateObject("Scripting.FileSystemObject")
    oFSO_I. 'No help from intellisense
 
'Early binding:
    'Need reference to M$ Scripting Runtime
    Dim oFSO_E As FileSystemObject
    Set oFSO_E = New FileSystemObject
    oFSO_E.CopyFile 'With help from intellisense

Compiling Late binding code will not discover errors to the object; it has no knowledge of the object.
Compiling early binding code will discover errors/typos immediately because the object is referenced and the compiler knows what to expect.

HTH

[Jamy]

Especially the implicit object reference has been used. The error is exactly as shown in the title of the thread.

The reference to scripting already has been enabled on both machines. In the code it's calling a module. That's the only difference between this event procedure and others used in db.

[Guus2005]

The FileSystemObject was only an example. Any object which was implicitly used can produce the error message.

Add error handling where you expect the error to appear.
You can even add errorlines to locate the exact line where to error occures.

Again an example. Don't try to compile, doesn't work, constants are missing. Is only an example

Function MapSelect(strPrompt As String)
          'Variables with a "c" prefix are constants
          Dim oSHApp
          Dim oFolder   ' as folder object
10        On Error GoTo Err_MapSelect
20        Set oSHApp = CreateObject("Shell.Application")
30        Set oFolder = oSHApp.BrowseForFolder(cDesktop, strPrompt, cOptions, cRootFolder)
40        MapSelect = oFolder.ParentFolder.ParseName(oFolder.Title).Path
Exit_MapSelect:
50        On Error GoTo 0
60        Exit Function
Err_MapSelect:
70        MsgBox "Error " & Err.Number & " (" & Err.Description & ") in line " & Erl & " in procedure MapSelect of Module Module1"
80        Resume Exit_MapSelect
90    Resume ' for debugging purposes
End Function

Enjoy!

[Jamy]

This is that strangest and dummest thing ever.

The computer involved didn't have access to the BE. His user was restricted on the server. Problem solved.

[Coxest]

hi, Jamy, I had the same problem. Thanks so much for the solution, but I'm dont know what means by BE which u mentioned the computer involved didn't have access to the BE, his user was restricted on the server. How im going to remove the restricted user from the server to allow the user to access ? Thanks a lot !