• Change table name

    Home » Forums » AskWoody support » Productivity software by function » MS Access and database help » Change table name

    Author
    Topic
    WSLindaR
    AskWoody Lounger
    January 14, 2010 at 5:31 am #465769

    I would like to make some names of tables more generic. Right now they are specific to a certain month. I would like to name them Baseline and Current. I would like the queries that use these tables to be changed also. Is there a way to do this. Same for queries – can you change a name of a query and have the subsequent queries that use that query, reflect the change.

    Reply | Quote
    Viewing 22 reply threads
    Author
    Replies
    • WSLindaR
      AskWoody Lounger
      January 14, 2010 at 5:31 am #1199111

      I would like to make some names of tables more generic. Right now they are specific to a certain month. I would like to name them Baseline and Current. I would like the queries that use these tables to be changed also. Is there a way to do this. Same for queries – can you change a name of a query and have the subsequent queries that use that query, reflect the change.

      Reply | Quote
    • WSLindaR
      AskWoody Lounger
      January 14, 2010 at 5:31 am #1199835

      I would like to make some names of tables more generic. Right now they are specific to a certain month. I would like to name them Baseline and Current. I would like the queries that use these tables to be changed also. Is there a way to do this. Same for queries – can you change a name of a query and have the subsequent queries that use that query, reflect the change.

      Reply | Quote
    • WSLindaR
      AskWoody Lounger
      January 14, 2010 at 5:31 am #1200593

      I would like to make some names of tables more generic. Right now they are specific to a certain month. I would like to name them Baseline and Current. I would like the queries that use these tables to be changed also. Is there a way to do this. Same for queries – can you change a name of a query and have the subsequent queries that use that query, reflect the change.

      Reply | Quote
    • WSLindaR
      AskWoody Lounger
      January 14, 2010 at 5:31 am #1201474

      I would like to make some names of tables more generic. Right now they are specific to a certain month. I would like to name them Baseline and Current. I would like the queries that use these tables to be changed also. Is there a way to do this. Same for queries – can you change a name of a query and have the subsequent queries that use that query, reflect the change.

      Reply | Quote
    • WSLindaR
      AskWoody Lounger
      January 14, 2010 at 5:31 am #1202287

      I would like to make some names of tables more generic. Right now they are specific to a certain month. I would like to name them Baseline and Current. I would like the queries that use these tables to be changed also. Is there a way to do this. Same for queries – can you change a name of a query and have the subsequent queries that use that query, reflect the change.

      Reply | Quote
    • WSLindaR
      AskWoody Lounger
      January 14, 2010 at 5:31 am #1203091

      I would like to make some names of tables more generic. Right now they are specific to a certain month. I would like to name them Baseline and Current. I would like the queries that use these tables to be changed also. Is there a way to do this. Same for queries – can you change a name of a query and have the subsequent queries that use that query, reflect the change.

      Reply | Quote
    • WSLindaR
      AskWoody Lounger
      January 14, 2010 at 5:31 am #1203983

      I would like to make some names of tables more generic. Right now they are specific to a certain month. I would like to name them Baseline and Current. I would like the queries that use these tables to be changed also. Is there a way to do this. Same for queries – can you change a name of a query and have the subsequent queries that use that query, reflect the change.

      Reply | Quote
    • WSunkamunka
      AskWoody Lounger
      January 14, 2010 at 10:23 am #1198346

      The way I would attempt to carry out what you are suggesting is to take a backup copy of the Database. In the backup, then edit the SQL in the various Queries that you have in mind – as well as copying & renaming the Tables.

      If you open up the relevant Query in DesignView, you should be able to see – depending on the circumstances – the relevant Table or Query that would need renaming.

      HTH

      Reply | Quote
    • WSunkamunka
      AskWoody Lounger
      January 14, 2010 at 10:23 am #1199303

      The way I would attempt to carry out what you are suggesting is to take a backup copy of the Database. In the backup, then edit the SQL in the various Queries that you have in mind – as well as copying & renaming the Tables.

      If you open up the relevant Query in DesignView, you should be able to see – depending on the circumstances – the relevant Table or Query that would need renaming.

      HTH

      Reply | Quote
    • WSunkamunka
      AskWoody Lounger
      January 14, 2010 at 10:23 am #1199895

      The way I would attempt to carry out what you are suggesting is to take a backup copy of the Database. In the backup, then edit the SQL in the various Queries that you have in mind – as well as copying & renaming the Tables.

      If you open up the relevant Query in DesignView, you should be able to see – depending on the circumstances – the relevant Table or Query that would need renaming.

      HTH

      Reply | Quote
    • WSunkamunka
      AskWoody Lounger
      January 14, 2010 at 10:23 am #1200651

      The way I would attempt to carry out what you are suggesting is to take a backup copy of the Database. In the backup, then edit the SQL in the various Queries that you have in mind – as well as copying & renaming the Tables.

      If you open up the relevant Query in DesignView, you should be able to see – depending on the circumstances – the relevant Table or Query that would need renaming.

      HTH

      Reply | Quote
    • WSunkamunka
      AskWoody Lounger
      January 14, 2010 at 10:23 am #1201528

      The way I would attempt to carry out what you are suggesting is to take a backup copy of the Database. In the backup, then edit the SQL in the various Queries that you have in mind – as well as copying & renaming the Tables.

      If you open up the relevant Query in DesignView, you should be able to see – depending on the circumstances – the relevant Table or Query that would need renaming.

      HTH

      Reply | Quote
    • WSunkamunka
      AskWoody Lounger
      January 14, 2010 at 10:23 am #1202341

      The way I would attempt to carry out what you are suggesting is to take a backup copy of the Database. In the backup, then edit the SQL in the various Queries that you have in mind – as well as copying & renaming the Tables.

      If you open up the relevant Query in DesignView, you should be able to see – depending on the circumstances – the relevant Table or Query that would need renaming.

      HTH

      Reply | Quote
    • WSunkamunka
      AskWoody Lounger
      January 14, 2010 at 10:23 am #1203145

      The way I would attempt to carry out what you are suggesting is to take a backup copy of the Database. In the backup, then edit the SQL in the various Queries that you have in mind – as well as copying & renaming the Tables.

      If you open up the relevant Query in DesignView, you should be able to see – depending on the circumstances – the relevant Table or Query that would need renaming.

      HTH

      Reply | Quote
    • WSunkamunka
      AskWoody Lounger
      January 14, 2010 at 10:23 am #1204043

      The way I would attempt to carry out what you are suggesting is to take a backup copy of the Database. In the backup, then edit the SQL in the various Queries that you have in mind – as well as copying & renaming the Tables.

      If you open up the relevant Query in DesignView, you should be able to see – depending on the circumstances – the relevant Table or Query that would need renaming.

      HTH

      Reply | Quote
    • WSpatt
      AskWoody Lounger
      January 14, 2010 at 1:23 pm #1198388

      Try Rick Fishers Find and Replace.

      Reply | Quote
    • WSpatt
      AskWoody Lounger
      January 14, 2010 at 1:23 pm #1199476

      Try Rick Fishers Find and Replace.

      Reply | Quote
    • WSpatt
      AskWoody Lounger
      January 14, 2010 at 1:23 pm #1199941

      Try Rick Fishers Find and Replace.

      Reply | Quote
    • WSpatt
      AskWoody Lounger
      January 14, 2010 at 1:23 pm #1200697

      Try Rick Fishers Find and Replace.

      Reply | Quote
    • WSpatt
      AskWoody Lounger
      January 14, 2010 at 1:23 pm #1201587

      Try Rick Fishers Find and Replace.

      Reply | Quote
    • WSpatt
      AskWoody Lounger
      January 14, 2010 at 1:23 pm #1202387

      Try Rick Fishers Find and Replace.

      Reply | Quote
    • WSpatt
      AskWoody Lounger
      January 14, 2010 at 1:23 pm #1203260

      Try Rick Fishers Find and Replace.

      Reply | Quote
    • WSpatt
      AskWoody Lounger
      January 14, 2010 at 1:23 pm #1204100

      Try Rick Fishers Find and Replace.

      Reply | Quote
    Viewing 22 reply threads
    Reply To: Reply #1201528 in Change table name

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information:




    Cancel
DON'T MISS OUT!
Subscribe to the Free Newsletter
We promise not to spam you. Unsubscribe at any time.
Invalid email address

View the Forum

  • Recent Replies
  • My Replies
  • My Active Topics
  • New Posts in the Last day
  • Private Messages
  • Knowledge Base
  • How to use the Forums
  • All Forums

    • Recent Topics

    My Profile

    May 2025
    S M T W T F S
     123
    45678910
    11121314151617
    18192021222324
    25262728293031

    Remembering Woody

     

    Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.

    Mastodon profile for DefConPatch
    Mastodon profile for AskWoody

     

    Home • About • FAQ • Posts & Privacy • Forums • My Account
    Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts

    Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.