[AccessD] AutoNumbers in historical tables

Susan Harkins harkins at iglou.com
Sun Jun 29 16:54:42 CDT 2003


You guys responded before seeing the ".... neveermind..."

I was doing something else and I just started in the wrong spot -- once I
went back I realized it was kind of a stupid question.

Susan H.


> 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
> >
> _______________________________________________
> 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