[AccessD] OT(kinda): Crack Code

Barry G. Herring herringb at charter.net
Wed Mar 21 15:38:49 CDT 2007


Maybe date and time are being converted to Base32 before being stored.

Ran into this in the military, they would store information in base32 to save on space.


Just a thought


Barry

---- David McAfee <davidmcafee at gmail.com> wrote: 

=============
well it looks like the first 3 digits could be the date. Look at your
sample:

 H9WDH701=02/06/03 09:19:55 AM
 H9WLA903=02/06/03 12:08:33 PM
 HLBDMS01=09/16/03 08:56:52 AM

The two dates 02/06/03 both start with H9W

The other date of 02/06/03 starts with HLB

there are 222 days difference between 02/06/03 and 09/16/09. Can HLB-H9W =
222?

I may need a few beers to get in the right mood ;)

David

On 3/21/07, Mark A Matte <markamatte at hotmail.com> wrote:
>
> This thing reminds me of the crypto toy at the end of the Davinci Code(8
> little wheels with letters and numbers).
>
> I think the sequence is jumbled as well.  In trying to solve I started
> dissecting a looking at individual characters.  I looked at the 8th(last
> character) for frequency.  The distribution didn't make much sense(listed
> below).  So I looked at the least, "C" to try and isolate a pattern...and
> found it was only the last char on 9/12/2001 and 9/19/2001...and not for
> all
> of the records.  I might pass it on to the University...but I'll probably
> just let it die...like it should have a long time ago.  The only reason
> they
> are still using it is that no one understood the relationships of the
> tables.  After I discovered that the fields OBJID in the different tables
> were not necessarily related...and that the 1 table with 2 keys in
> it...was
> actually related to itself 3 or more times...we made leaps and
> bounds...for
> the first time they could say definitively that they were missing records.
>
> Any way...thanks again everyone.
>
> Mar A. Matte
>
>
> LastChar        Count
> 1       151767
> 2       114816
> 3       88366
> 4       63108
> 5       33900
> 6       24099
> 7       14439
> 8       8886
> 9       5427
> A       1743
> B       634
> C       115
>
> >From: "Dan Waters" <dwaters at usinternet.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 14:01:26 -0500
> >
> >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
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >--
> >AccessD mailing list
> >AccessD at databaseadvisors.com
> >http://databaseadvisors.com/mailman/listinfo/accessd
> >Website: http://www.databaseadvisors.com
>
> _________________________________________________________________
> 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
>
>
-- 
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