Topic: Change table name @ AskWoody

Change table name
Home » Forums » AskWoody support » Productivity software by function » MS Access and database help » Change table name
- This topic has 23 replies, 3 voices, and was last updated 15 years, 3 months ago.
Author

Topic
New Reply

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: 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:
Name (required):

Mail (will not be published) (required):

Website:

Cancel

Plus Membership

Donations from Plus members keep this site going. You can identify the people who support AskWoody by the Plus badge on their avatars.

AskWoody Plus members not only get access to all of the contents of this site -- including Susan Bradley's frequently updated Patch Watch listing -- they also receive weekly AskWoody Plus Newsletters (formerly Windows Secrets Newsletter) and AskWoody Plus Alerts, emails when there are important breaking developments.

Welcome to our unique respite from the madness.

It's easy to post questions about Windows 11, Windows 10, Win8.1, Win7, Surface, Office, or browse through our Forums. Post anonymously or register for greater privileges. Keep it civil, please: Decorous Lounge rules strictly enforced. Questions? Contact Customer Support.

Change table name

Plus Membership

Search Newsletters

Search Forums

View the Forum

Search for Topics

Recent Topics

Recent blog posts

My Profile

Key Links

Remembering Woody

Change table name

Plus Membership

Search Newsletters

Search Forums

View the Forum

Search for Topics

Recent Topics

Recent blog posts

My Profile

Login and Registration

Key Links

Remembering Woody