Results 1 to 2 of 2
  1. #1
    budchevy is offline Novice
    Windows XP Access 2003
    Join Date
    Feb 2012
    Posts
    15

    delete query setup then table name changed


    I have a delete query setup but I needed to change the name of the table it's linked to. Is there an easy way to change the query to look at the new table name?

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,522
    If you go into SQL view, it should look something like

    DELETE * FROM TableName

    You can change the table name there.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 01-24-2012, 02:16 PM
  2. make table query wants to delete itself
    By peter_lawton in forum Queries
    Replies: 11
    Last Post: 12-15-2011, 12:28 PM
  3. Replies: 11
    Last Post: 03-30-2011, 01:08 PM
  4. Please help with table setup
    By newhelpplease in forum Access
    Replies: 0
    Last Post: 10-14-2007, 01:15 PM
  5. Delete query, deleting customers froma table.
    By keithsrobinson in forum Queries
    Replies: 2
    Last Post: 02-14-2006, 11:33 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums