[AccessD] OT(kinda): Crack Code

Charlotte Foust cfoust at infostatsystems.com
Wed Mar 21 19:09:13 CDT 2007


Sounds ugly!  I had to deal with data out of an Informix database at the
US Bureau of Reclamation, but fortunately, someone had written  routines
to dump it into CSV format, if I remember correctly.  My mission was
just to take the year's worth of records and make sense of them.

Charlotte Foust 

-----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 2:03 PM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] OT(kinda): Crack Code

lol...If you want to try just to do it...I will put something
together...I have to go to a Win95 machine and enter 1 OBJID at a
time...and write it down the DT.  I probably have around 10
million...I'll see if I can get a 100.


>From: "Rocky Smolin at Beach Access Software" <rockysmolin at bchacc.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 13:57:21 -0700
>
>Mark:
>
>Can you post maybe 100 or so to give us a little more sample to go on?
>
>Or send a spreadsheet to those of us who like these things with all of 
>the OBJIDs and dates (how many are there?)?
>
>Rocky
>
>
>
>
>
>
>
>
>-----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 12:26 PM
>To: accessd at databaseadvisors.com
>Subject: Re: [AccessD] OT(kinda): Crack Code
>
>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/PreparationT
ips.
> >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=T002MSN0
> >3A
> >07001
> >
> >--
> >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
>
>_________________________________________________________________
>Its tax season, make sure to follow these few simple tips 
>http://articles.moneycentral.msn.com/Taxes/PreparationTips/PreparationT
>ips.a
>spx?icid=HMMartagline
>
>
>--
>No virus found in this incoming message.
>Checked by AVG Free Edition.
>Version: 7.5.446 / Virus Database: 268.18.15/728 - Release Date: 
>3/20/2007
>8:07 AM
>
>
>
>--
>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



More information about the AccessD mailing list