Mark A Matte
markamatte at hotmail.com
Wed Mar 21 13:36:00 CDT 2007
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