A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Changing the name of a table that then relates to a query



 
 
Thread Tools Display Modes
  #1  
Old January 26th, 2010, 03:29 PM posted to microsoft.public.access.tablesdbdesign
Aimee Proctor
external usenet poster
 
Posts: 1
Default Changing the name of a table that then relates to a query

I changed the name of a table that relates to a lot of queries.....these now wont work....how do i resolve this....thanks for ANY news!


Submitted via EggHeadCafe - Software Developer Portal of Choice
ADO.NET Recursive Hierarchical DataSet Technique
http://www.eggheadcafe.com/tutorials...e-hierarc.aspx
  #2  
Old January 26th, 2010, 04:08 PM posted to microsoft.public.access.tablesdbdesign
Jerry Whittle
external usenet poster
 
Posts: 4,732
Default Changing the name of a table that then relates to a query

1. Change the table name back to its orginal name.

2. Download Rich Fisher's excellent Find and Replace add-in and change
everything to match the new table name. If you register it (one of the best
$37 I've ever spent), the cross-reference report can find what queries use
which reports and forms. It's a good way to find orphans.
http://www.rickworld.com/

3. Enable Name Autocorrect so that you won't have this problem in the
future. However Name Autocorrect is often a problem and I don't recommend
using it.

4. Remember that changing the name of a table, field in a table, query, and
possibly even forms and reports can cause this problem. It's better to get
the names right in the first place or don't mess with them.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"Aimee Proctor" wrote:

I changed the name of a table that relates to a lot of queries.....these now wont work....how do i resolve this....thanks for ANY news!


Submitted via EggHeadCafe - Software Developer Portal of Choice
ADO.NET Recursive Hierarchical DataSet Technique
http://www.eggheadcafe.com/tutorials...e-hierarc.aspx
.

  #3  
Old January 27th, 2010, 09:49 AM posted to microsoft.public.access.tablesdbdesign
elizas
external usenet poster
 
Posts: 1
Default Changing the name of a table that then relates to a query

Hi,
please check it it helps.Suppose there is requirement for selecting
records from more than one Database.
Let's say, you have different databases for different branch (say: BRANCH1_DB,
BRANCH2_DB, BRANCH3_DB).
For getting all employees name write the following query:
SELECT (FIRST_NAME + ' ' + LAST_NAME) AS EMPLOYEE_NAME FROM BRANCH1_DB.dbo.
EMPLOYEE_INFO
UNION ALL
SELECT (FIRST_NAME + ' ' + LAST_NAME) AS EMPLOYEE_NAME FROM BRANCH2_DB.dbo.
EMPLOYEE_DETAILS
UNION ALL
SELECT (FNAME + ' ' + LNAME) AS EMPLOYEE_NAME FROM BRANCH3_DB.dbo.EMPLOYEE

Thanks
Eliza
http://www.mindfiresolutions.com/dat...evelopment.htm
Aimee Proctor wrote:
I changed the name of a table that relates to a lot of queries.....these now wont work....how do i resolve this....thanks for ANY news!

Submitted via EggHeadCafe - Software Developer Portal of Choice
ADO.NET Recursive Hierarchical DataSet Technique
http://www.eggheadcafe.com/tutorials...e-hierarc.aspx


  #4  
Old January 28th, 2010, 09:12 AM posted to microsoft.public.access.tablesdbdesign
Piet Linden[_2_]
external usenet poster
 
Posts: 280
Default Changing the name of a table that then relates to a query

On Jan 26, 8:29*am, Aimee Proctor wrote:
I changed the name of a table that relates to a lot of queries.....these now wont work....how do i resolve this....thanks for ANY news!

Submitted via EggHeadCafe - Software Developer Portal of Choice
ADO.NET Recursive Hierarchical DataSet Techniquehttp://www.eggheadcafe.com/tutorials/aspnet/f492b744-8326-4671-a7c3-9...


loop through the Querydefs collection and use the Replace function to
modify the SQL property might work...
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:13 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.