Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Location
    Slovenia
    Posts
    18

    Exclamation Unanswered: Strange "Object not set" error in a query

    Helo everbody - I need some help.

    I'm using Access 2000...

    I have linked tables from Oracle database and Access 2000 aplication.
    I'm filling (via append query) a temp Access table named Zavodi, which is limiting my data when opening varius forms. Table data may be deleted and inserted many times in normal working proces. (I use delete and append query). Table's data are ID's of some records in original table - one column full of Integer data.

    The problem:
    On my computer (Win XP, Access 2000) is all working fine.
    On a different computer (Win XP, Access 2000) I'm getting "object not set" error when opening forms. I was looking for an error in my coding I got this:
    All these forms have table Zavodi used in their Record Source. When I remove table form query is all working fine. I can also open table Zavodi with no problem. But if I use it in a query - It's not working!!!!!

    Has someone some idea? I would need some help realy fast. What sould I look for?
    www.SloMusic.com

  2. #2
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    Just compare your Preferences and that on the other computer. I think you use some objects or prefernces which are not installed there

Posting Permissions

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