Results 1 to 7 of 7
  1. #1
    Star Lounger
    Join Date
    Mar 2003
    Location
    Summerville, South Carolina, USA
    Posts
    66
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Undefined Function (Access 2000)

    I manage a multi-user database. Most of the tables are linked to Oracle. I am getting a message "undefined function 'trim' in expression" when I go into the database. Some of my users can go into it, while other can't. I am not sure why. Can anyone help?

    Thanks

  2. #2
    Silver Lounger
    Join Date
    Jun 2002
    Location
    Cheadle, Staffordshire
    Posts
    2,177
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Undefined Function (Access 2000)

    It sounds like a broken reference to an ActiveX component or DAO

    Check your references to see if any say "MISSING" and uncheck them.
    If this still happens when re-booting the database, you may have to re-register them.

  3. #3
    Star Lounger
    Join Date
    Mar 2003
    Location
    Summerville, South Carolina, USA
    Posts
    66
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Undefined Function (Access 2000)

    Hi Dave. I checked the references and did not see anything MISSING. Any other ideas? It has worked for the last few days but now it doesn't. When checking your references, I am assuming you are talking about the VBA references. If you can walk me through that, I would appreciate it. Thanks.

  4. #4
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Jerusalem, Israel
    Posts
    708
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Undefined Function (Access 2000)

    I have been looking for a while for someone with Oracle linked to Access databases. I have oracle 7 running as a backend, and I cannot find a wayto link through odbc to XP. Do you h ave any ideas about that?
    Thanks

  5. #5
    Silver Lounger
    Join Date
    Jun 2002
    Location
    Cheadle, Staffordshire
    Posts
    2,177
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Undefined Function (Access 2000)

    Go to any module or form module.
    On the top menu Tools|References.
    Check the contents on the fault machines are the same as the contents on the ok machine.
    If any are not checked in the tick box's, then tick them.
    If they are just not there, use the browse button to locate them in either the System or System32 folder.

    Hope this helps.

  6. #6
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Undefined Function (Access 2000)

    I'd suggest you post this as a separate thread. There have been past discussions of linking to Oracle, but with the search engine out of commission and a necessary pruning of the archives, I don't have a link to give you. Someone else might be able to help if you make the subject explicit.
    Charlotte

  7. #7
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Jerusalem, Israel
    Posts
    708
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Undefined Function (Access 2000)

    I did that once and got no response but will try again.
    Thanks

Posting Permissions

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