[AccessD] OT(kinda): Crack Code

Dan Waters dwaters at usinternet.com
Wed Mar 21 14:01:26 CDT 2007


Mark,

Perhaps you could contact the math department at a nearby university.  They
may want to take a whack at this, or they may know someone who would think
that solving this kind of puzzle is great fun!

Dan Waters

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark A Matte
Sent: Wednesday, March 21, 2007 1:36 PM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] OT(kinda): Crack Code

I have found also that if I sort on the key...the corresponding times are 
also sorted correctly.


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

_________________________________________________________________
Watch free concerts with Pink, Rod Stewart, Oasis and more. Visit MSN 
Presents today. 
http://music.msn.com/presents?icid=ncmsnpresentstagline&ocid=T002MSN03A07001

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