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 - 03 Aug 2004 12:43 GMT
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.

Signature
More info, please ...
Jeff Boyce
<Access MVP