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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|