Question on update table

[pei]

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.

 

[Jeff Boyce]

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.

 

[Jeff Boyce]

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.