If I have a table that has been expanded since it was last archived (i.e., additional fields added), can I append records from the expanded table to the same archive table (i.e., would the append query add the new fields as well)? Or would the data be truncated to the fields already present in the archive table?
For example: Archiving customers that have not purchased in 5 years. Fields for NameSuffix and NamePrefix were Added 3 years ago, but the Customer table has bee running for 10 years. This next archiving will attempt to append 10 records with the two new fields. What would access do based upon what was covered in class?
Michael, I would recommend adding the new fields to your backup table. It's the best way to be sure the new records will copy over. I do this myself because I have a local Access database that continuously backs up stuff from my website (including this Forum) and if I add a new field to the online SQL Server table, I have to make sure I add it to my Access backup table or else it craps out.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Expert 15.
