[AccessD] AutoNumbers in historical tables

Just out of interest why would you want to?

Martin

Quoting Jim Dettman <jimdettman at earthlink.net>:

> Susan,
> 
>   Depends on how much tractability you need/want.  Typically in a data
> mart,
> you don't touch any of the original data including the keys, meaning
> that
> you add a new key structure outside of any existing.
> 
>   Also depends a lot on how your DB is structured: natural or
> surrogate.
> 
> Jim Dettman
> President,
> Online Computer Services of WNY, Inc.
> (315) 699-3443
> jimdettman at earthlink.net
> 
> -----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
>