Results 1 to 6 of 6
  1. #1
    New Lounger
    Join Date
    Sep 2008
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    error 3167 (2002)

    Hello, any help would be much appreciated. I am attempting to resolve a Error 3167 on the database of an absent colleague. It has 1852 entries so isn't huge but is made up of sub forms and tables. There are no built in delete functions. All queries return a record deleted error message howevet the source tables are intact. If I rebuild a query it return a result initially but then produces a record is deleted message with a help and Ok button. If I click OK the results are changed in to text that reads: #Name? in every field. Could you tell me what is happening and how to remedy it? I'm afraid that my Access experience is quite limited. The colleague had organised for backups but the administrator tells me she has deleted them. Exportiing isn't working at the moment but I'll keep trying. I have checked through other related posts so hope I haven't missed similar.

  2. #2
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: error 3167 (2002)

    #Name? usually means you have misspelt a field in a table.

    Why dont you send a zipped compacted database so we can see what the problem. Tell us whic query is incorrect.

  3. #3
    New Lounger
    Join Date
    Sep 2008
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: error 3167 (2002)

    Thank you for the quick response. Unfortunately I can't send it externally because of sensitive data. There are about forty queries on the database and none of them work...all produce the same error message. I've exported the two main tables into a new database and rebuilt the main query which is now working fine. the spelling looks OK. Is there anything else I could check on the original? I don't have an original so can't check for spacing changes.

  4. #4
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: error 3167 (2002)

    Try doing a Compact and Repair Tools...Database Utilites...Compact and Repair.
    Regards
    John



  5. #5
    New Lounger
    Join Date
    Sep 2008
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: error 3167 (2002)

    It worked!!!! what an enormous relief, thank you <img src=/S/bravo.gif border=0 alt=bravo width=16 height=30>

  6. #6
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: error 3167 (2002)

    You are lucky. It often works, but not always.

    Make another backup now.
    Regards
    John



Posting Permissions

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