Dan Waters
dwaters at usinternet.com
Wed Dec 28 21:18:01 CST 2005
Joe, I believe that this is correct. But test first - copy the table and save it with a new name. Then go through your examples below to verify that what you believe will happen actually does happen. Dan -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Joe Hecht Sent: Wednesday, December 28, 2005 8:32 PM To: 'Access Developers discussion and problem solving' Subject: [AccessD] Edit Table for Normalization Again If I have a table and remove some fields then 1. If I save as a new table name no data is saved. I have the new structure only. 2. If I save edited table with same name, remaining field data remains. Does that seem correct? Joe Hecht jmhecht at earthlink.net -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com