[AccessD] AutoNumbers in historical tables

Susan Harkins harkins at iglou.com
Sat Jun 28 17:44:00 CDT 2003


I didn't mean to send that -- completely disregard it -- it's a silly
question after reviewing it. I was thinking about something related and just
started at the wrong spot I think.

Susan H.
----- Original Message -----
From: "John Colby" <jcolby at colbyconsulting.com>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Saturday, June 28, 2003 5:50 PM
Subject: RE: [AccessD] AutoNumbers in historical tables


> 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
>
>
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>




More information about the AccessD mailing list