Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    May 2004
    Location
    San Francisco, California, USA
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    2000 vs. 2003 (Access 2000)

    Can someone give me a clue as to why this expression in a query in Access 2000:

    Like "*" & Left([Enter Last Name:],4) & "*"

    Returns an error message when using Access 2003?

    Thanks,

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

    Re: 2000 vs. 2003 (Access 2000)

    "Returns an error message" is not very specific.

    1. Activate the Visual Basic Editor (Alt+F11), then select Tools | References.... Clear the check box for any references starting with MISSING, then click OK. See if that gets rid of the problem.

    2. See if temporarily setting Macro Security (Tools | Macro | Security...) to Low helps.

    3. See How to configure Jet 4.0 to prevent unsafe functions from running in Access 2003 for an overview of the new "Sandbox Mode" in Access 2003. This MSKB article also explains how to turn Sandbox Mode on or off.

  3. #3
    New Lounger
    Join Date
    May 2004
    Location
    San Francisco, California, USA
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 2000 vs. 2003 (Access 2000)

    Thanks very much Hans. The missing reference tip appears to have worked.

Posting Permissions

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