Mark A Matte
markamatte at hotmail.com
Thu Mar 22 09:16:45 CDT 2007
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=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 > >-- >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_hmemailtaglinemarch07