Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Mar 2004
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Error 3072 (Access 2000 SP3)

    When I run one of my self-written functions, via a macro, I get the following error:
    Runtime Error 3072 - Unknown function name
    on the following line
    xqry_Q_Guest_Uncancelled.FindFirst xGUEST_Criteria

    HELP on this error says
    There was a type mismatch when creating a table validation rule or a CHECK constraint on a column. (Error 3072)

    The recordset has been previously defined and set up via:
    Dim xqry_Q_Guest_Uncancelled As Recordset
    Set xqry_Q_Guest_Uncancelled = xdb_ICA.OpenRecordset("Q_Guest_Uncancelled", dbOpenDynaset)

    The thing is that other workstations on the network run this same function with no problems. So I figure it must be some configuration issue on the failing workstation.

    It is running Win98 SE. I have applied the SP 1, 2, and 3 patches to Access 2000, as well as the Jet40SP7_9xNT.exe ODBC patch.

    Anyone have any ideas why this one workstation might be failing this way?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Error 3072 (Access 2000 SP3)

    Check for missing references. You MUST do this on the workstation that displays the problem.
    Open the database on that workstation, activate the Visual Basic Editor, and select Tools | References...
    Does any of the selected references start with MISSING?

  3. #3
    New Lounger
    Join Date
    Mar 2004
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Error 3072 (Access 2000 SP3)

    Thanks, Hans, for your reply.

    I looked at the references. The same ones are "checked" on both the working and non-working workstations, and none of the non-working workstation's references are marked as "Missing".

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Error 3072 (Access 2000 SP3)

    Try re-registering DAO on the problem machine:
    - Find out where DAO360.dll is installed; the default location is C:Program FilesCommon FilesMicrosoft SharedDAO.
    - Select Start | Run...
    - Type

    regsvr32 "C:Program FilesCommon FilesMicrosoft SharedDAODAO360.dll"

    substituting the correct path; then press Enter or click OK.

  5. #5
    New Lounger
    Join Date
    Mar 2004
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Error 3072 (Access 2000 SP3)

    Thanks again Hans for your reply.

    I tried the re-reg you suggested, even re-booting after I did it, but it didn't solve the problem.

    I eventually "fixed" the problem by having the query build a temporary table, then changing the module to FINDFIRST from the table instead of the query. I have found this to be a good "cure-all" for query problems. So the mystery is unsolved but the problem is remedied!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •