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.

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

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

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

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