Results 1 to 3 of 3
  1. #1
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    =Left(Command(),3) Returning #Name? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)

    I have the following Text Box on a Form:

    <pre>Text Box
    Name: Command
    Control Sourse: =Left(Command(),3)
    </pre>


    When running on Microsoft Access 2000 and 2002

    It is returning TOC

    When running on Microsoft Access 2003 (11.6566.6568) SP2 or any version of 2003 on different client

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

    Re: =Left(Command(),3) Returning #Name? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)

    This is probably caused by the increased security in Access 2003. See How to configure Jet 4.0 to prevent unsafe functions from running in Access 2003.

  3. #3
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: =Left(Command(),3) Returning #Name? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)

    Thanks for the link, after further review:

    I changed =Left(Command(),3) to a Function =GetCommand3() and put Left(Command(),3) in VBA code and it works OK

    To make your system more resistant to malicious attacks, and at the same time make it possible for older applications to keep running, the operation of Sandbox mode changed in Jet 4.0 Service Pack 8 so that Sandbox mode is completely under your control.

    You can set the registry value to the following values, with 0 (zero) being the most permissive and 3 being the least permissive. This registry value is of type DWORD.

    0 Sandbox mode is disabled at all times.
    1 Sandbox mode is used for Access applications, but not for non-Access Applications.
    2 Sandbox mode is used for non-Access applications, but not for Access Applications. This is the default value.
    3 Sandbox mode is used at all times.

    1. All Access 2000+ developers should upgrade their version of jet 4 to SP8 most current version 4.0.8618.0

    2. Access 2000 & 2002 default install SandboxMode = 2

    3. Access 2003 default install SandboxMode = 3

    4. All Access 2000+ developers should Set HKEY_LOCAL_MACHINESoftwareMicrosoftJet4.0enginesSa ndboxMode = 3 so all land mines will fire while developing.

    5. All users should perform step 1 before upgradeing to Access 2003

    Installing Access/Office 2003 With Care
    http://www.vb123.com/toolshed/03_access/install.htm

    Additional comments from others who have migrated from 2000 to 2003 are welcomed.

    HTH others

    Thanks, 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
  •