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
|
|||
|
|||
Question on update table
To All
How do I "update or replace a table" in the data base with new information without loosing my connection to forms that I have created? ( I am hesitating to use use "append table" because I have added information and new field on the new table. ) What I have done so far, is rename the old table, and name the new table with the old name; to do this I had to delete the relationship and connect the relationship of old form to new table. But what I have found was that although the control source property is the same and the form shows up in design view, but I can no longer view any data information in form view. What is your suggestion? P.S. I have a back up of the data base. |
#2
|
|||
|
|||
Question on update table
Pei
Why do you feel you need to replace a table? We're not there, so we can't see what situation you are dealing with. It may be that there's another solution besides replacing the entire table. -- More info, please ... Jeff Boyce Access MVP |
#3
|
|||
|
|||
Question on update table
I need to replace the table because there were new rows of data added and a new field was added. I made the change on the original table in excel spread sheet then imported the table back to access.
"Jeff Boyce" wrote: Pei Why do you feel you need to replace a table? We're not there, so we can't see what situation you are dealing with. It may be that there's another solution besides replacing the entire table. -- More info, please ... Jeff Boyce Access MVP |
#4
|
|||
|
|||
Question on update table
Does your form rely on a query of the table for its data source? What
happens when you run that query, independently of the form? It isn't necessary to replace a table to append new rows... and it isn't necessary to replace a table to add a new field. Open the table in design mode and add the field. Import (or link to) the Excel data, into a temporary, import table. Write a query that reads the import table and appends to the revised table, in the appropriate fields. If you are saying that you also need to update some values in that Access table, use an update query. -- Good luck Jeff Boyce Access MVP |
#5
|
|||
|
|||
Question on update table
Jeff,
Thank you so much for your help. I ran the query and it returned empty. It happens that one of the table has empty data in it which I didn't realize. Once I fill in the "key" data, the problem is solved. Thanks again Pei "Jeff Boyce" wrote: Does your form rely on a query of the table for its data source? What happens when you run that query, independently of the form? It isn't necessary to replace a table to append new rows... and it isn't necessary to replace a table to add a new field. Open the table in design mode and add the field. Import (or link to) the Excel data, into a temporary, import table. Write a query that reads the import table and appends to the revised table, in the appropriate fields. If you are saying that you also need to update some values in that Access table, use an update query. -- Good luck Jeff Boyce Access MVP |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Update Excel Table with ADO and SQL | Todd Huttenstine | Running & Setting Up Queries | 1 | July 22nd, 2004 03:58 PM |
Newbie? Do I use Report or Query | John Egan | New Users | 11 | June 28th, 2004 08:31 PM |
Can't update table from Form | sara | Using Forms | 3 | June 11th, 2004 02:12 PM |
Table design question - advice needed | David | Database Design | 3 | June 8th, 2004 02:21 AM |
Cannot join 1:M table into M:M tables | Tom | Database Design | 4 | May 19th, 2004 10:16 PM |