Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    Aug 2001
    Location
    London, UK
    Posts
    516
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Run SQL command (access 2000)

    Does any body see anything wrong with the following SQL statement? Its giving me an error on the FROM clause, is it because I have space in the table name?

    DELETE SFM Report Source. *
    FROM SFM Report Source
    WITH OWNERACCESS OPTION;

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Run SQL command (access 2000)

    Put brackets around the table name

    DELETE [SFM Report Source].*
    FROM [SFM Report Source]
    WITH OWNERACCESS OPTION;

    And for the future and to make your life a little simpler, stop to use spaces in names for object (Tables, fields, forms, ... even in Windows, for Directories and Files)
    If MicroSoft allows you to do it, it is many times source of trouble.
    IMHO, names should only contain letters, numbers and underscores.

    PS You have also a space between . and * Remove it also
    Francois

  3. #3
    4 Star Lounger
    Join Date
    Aug 2001
    Location
    London, UK
    Posts
    516
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Run SQL command (access 2000)

    Wow it works, THANK YOU soooooooooo much Francois.

Posting Permissions

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