Rocky Smolin at Beach Access Software
rockysmolin at bchacc.com
Thu Mar 22 14:22:23 CDT 2007
THAT'S NUTZ! But it sounds like progress. I would send him this latest
post of yours and as many examples as you can muster without doing too much
work. He wrote back and said he's not good with codes but he has colleagues
in the department that love this stuff. And if he ever gets back from skiing
he'll run it by them.
Rocky
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark A Matte
Sent: Thursday, March 22, 2007 11:08 AM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] OT(kinda): Crack Code
Rocky,
I've actually made some progress. Last year I learned how to do Mayan Math
and applied the logic as a counting system not 10 or 20 base...but 36...and
after learning that this thing is counting seconds since 1/1/70 00:00:00...I
assigned values to the numbers and letters. and started running some tests.
0=0,1=1,2=2...9=9,A=10,B=11...Z=35.
This makes it a 36 base counting system...so you take the value of each
position...calculate and add like below:
1st ???
2nd ???
3rd Value*60466176
4th Value*1679616
5th Value*46656
6th Value*1296
7th Value*36
8th Value
So if you had 00bfk5t2...you math would be Value of third position
('B'11*60466176) added to each position calculated...so:
0's are 0...('B'11*60466176)
+('F'15*1679616)+('K'20*46656)+('5'5*1296)+('T'29*36)+('2'2)
Beginning of time for this count is 12/31/69 04:00:00 PM...if you do the
calcs above you get 691262822...if you add this many seconds to the
beginning time you get 11/27/91 9:27:02 AM...
Which validates in the system. The guy I talked to that help create it over
12 years ago...said he remembered something about haveing to 'shift a bit or
2'...but I didn't get much more from him...he just didn't remember the
specifics. The 1st and 2nd positions I am having issues with...if I try to
calculate it out...I get crazy results...and also in the validation
tool...with the above example it validated...but if I added a
letter(00bfk5t2 changed to 0bbfk5t2)...just added value in second
position...it would not accept it as valid??? This is probably what he was
talking about"Shifting a bit or 2".
Anyway...any thoughts?
What info would your cousin need?
Thanks,
Mark A. Matte
>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: Thu, 22 Mar 2007 09:56:20 -0700
>
>If it takes less than about 6 minutes...:)
>
>I was going to send it to my cousin - a retired math prof. He likes that
>sort of thing
>
>Rocky
>
>
>
>
>
>
>
>
>-----Original Message-----
>From: accessd-bounces at databaseadvisors.com
>[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark A Matte
>Sent: Thursday, March 22, 2007 7:17 AM
>To: accessd at databaseadvisors.com
>Subject: Re: [AccessD] OT(kinda): Crack Code
>
>The date is stored in the table...but not the time. If you want a
>date/time...I have to plug the OBJID into the FE and it converts it for me.
>
>I can extract the date and the OBJID...but you can have up to 86400
>different OBJIDs for 1 date. I can try to get about 100 if you like.
>
>Mark
>
>
> >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 15:50:57 -0700
> >
> >Oh. You can't extract them from the file?
> >
> >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 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/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=T002MS
> > > >N0
> > > >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/Preparatio
> > >nT
> > >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
> >
> >--
> >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
>
>_________________________________________________________________
>Exercise your brain! Try Flexicon.
>http://games.msn.com/en/flexicon/default.htm?icid=flexicon_hmemailtaglinema
r
>ch07
>
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com
>
>--
>No virus found in this incoming message.
>Checked by AVG Free Edition.
>Version: 7.5.446 / Virus Database: 268.18.16/729 - Release Date: 3/21/2007
>7:52 AM
>
>
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com
_________________________________________________________________
The average US Credit Score is 675. The cost to see yours: $0 by Experian.
http://www.freecreditreport.com/pm/default.aspx?sc=660600&bcd=EMAILFOOTERAVE
RAGE
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.446 / Virus Database: 268.18.16/729 - Release Date: 3/21/2007
7:52 AM