John Colby
jcolby at colbyconsulting.com
Sat Jun 28 16:50:07 CDT 2003
could you be a little more specific in your question? Do you mean in the destination (archive) table? In the source table? In fact I don't change either. You just have to be sure that you leave the latest record in the source table so that compact and repair doesn't reset the autonumber. In the destination it would be a good idea to change the PK autonumber to a regular long to avoid the issue of compact resetting the autonumber, though since the only data going in is the data from the source, it seems unnecessary in any case. John W. Colby www.colbyconsulting.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Susan Harkins Sent: Saturday, June 28, 2003 5:27 PM To: AccessD at databaseadvisors.com Subject: [AccessD] AutoNumbers in historical tables When archiving historical data do you change an AutoNumber field to a Number field? Like to hear pros and cons on the subject. Susan H. _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com