Dropping a table in MS Access using SQL

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • zam214
    New Member
    • Jan 2013
    • 1

    Dropping a table in MS Access using SQL

    good evening everyone, i can't drop a table using this sql command DROP TABLE tablename;

    please help me..
  • Anas Mosaad
    New Member
    • Jan 2013
    • 185

    #2
    The Microsoft Access database engine does not support the use of DROP, or any of the DDL statements, with non-Microsoft Access database engine databases.

    If this is not the case, What is error you have got?

    Here's a reference from the MSDN DROP Statement.
    Last edited by NeoPa; Jan 7 '13, 09:36 PM. Reason: No reason for information to be spread across different posts.

    Comment

    • NeoPa
      Recognized Expert Moderator MVP
      • Oct 2006
      • 32668

      #3
      Please see Finding Jet SQL Help for how to check what is, and isn't, available.

      If you are still having problems then you will need to post your question properly and we will see what we can do to help. This could not be considered a proper question.

      Comment

      Working...