[AccessD] OT(kinda): Crack Code

good gravy those alphanumeric codes are indeed alphanumeric... I thought
maybe it was md5 hashed so you can do lookups to determine original value
but if there is a tool to reverse value back to datetime maybe it is not a
hashed string.


On 3/21/07, Mark A Matte <markamatte at hotmail.com> wrote:
>
> The reason I need to convert back...is that I have about 40K orphaned
> records.  There is no date or time stamp in this table.  If I can convert
> the OBJID back to a date/time...I might be able to re-establish some of
> the
> relationships by adjusting these times...or at least give an accurate
> timeline of when the relation ship was lost.  Below are some examples.
>
> OBJID
> H9WDH701=02/06/03 09:19:55 AM
> H9WLA903=02/06/03 12:08:33 PM
> HLBDMS01=09/16/03 08:56:52 AM
> H0HEOO01=08/07/02 09:19:36 PM
> IYY5UQ01=05/08/06 05:40:02 AM
>
>
> >From: "Billy Pang" <tuxedoman888 at gmail.com>
> >Reply-To: Access Developers discussion and problem
> >solving<accessd at databaseadvisors.com>
> >To: "Access Developers discussion and problem
> >solving"<accessd at databaseadvisors.com>
> >Subject: Re: [AccessD] OT(kinda): Crack Code
> >Date: Wed, 21 Mar 2007 09:52:24 -0700
> >
> >can you post an example of a record with the key?
> >
> >also, why do you need to convert these keys back to datetime?
> >
> >
> >On 3/21/07, Mark A Matte <markamatte at hotmail.com> wrote:
> > >
> > > Hello All,
> > >
> > > I have a DB...just the data...no FE...all of the Keys are 8 character
> > > alpha-numeric.  This key is generated from the date time.  The company
> > > that
> > > developed the app no longer exists.  I need to figure out the logic
> >used,
> > > and convert these keys back to date time.  I've searched online for
> any
> > > reference to the company/software...and no luck.
> > >
> > > Any ideas/directions...anything?
> > >
> > > Thanks,
> > >
> > > Mark A. Matte
> > >
> > > _________________________________________________________________
> > > It's tax season, make sure to follow these few simple tips
> > >
> > >
> >
> http://articles.moneycentral.msn.com/Taxes/PreparationTips/PreparationTips.aspx?icid=HMMartagline
> > >
> > >
> > > --
> > > AccessD mailing list
> > > AccessD at databaseadvisors.com
> > > http://databaseadvisors.com/mailman/listinfo/accessd
> > > Website: http://www.databaseadvisors.com
> > >
> > >
> >
> >
> >--
> >Billy Pang
> >http://dbnotes.blogspot.com/
> >"Once the game is over, the King and the pawn go back in the same box." -
> >Italian proverb
> >--
> >AccessD mailing list
> >AccessD at databaseadvisors.com
> >http://databaseadvisors.com/mailman/listinfo/accessd
> >Website: http://www.databaseadvisors.com
>
> _________________________________________________________________
> Get a FREE Web site, company branded e-mail and more from Microsoft Office
> Live! http://clk.atdmt.com/MRT/go/mcrssaub0050001411mrt/direct/01/
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>



-- 
Billy Pang
http://dbnotes.blogspot.com/
"Once the game is over, the King and the pawn go back in the same box." -
Italian proverb