Mark A Matte
markamatte at hotmail.com
Wed Mar 21 14:11:34 CDT 2007
Thanks Gary, I found them...they haven't called back either. I have determined(I think)...that is is impossible to rebuild the relationships in these tables due to how the key is used. A customer is created...with this type of key. Then images are scanned in. Each image gets its own key. Then when the user relates the scan to the customer a record is created in a seperate table storing the cust key in 1 field and the scan key in another. Oh and did I mention...there is a record in the same table where the relationship itself gets its own key. All keys appear to be created with the same algorithm. So I can have 5 records with the same relationship key, but different scan and cust keys. This is just silly. They are out of business...but were pulling over 10 mil USD a year. Guess they thought "WOW...suckers bought it...lets run away while we can...Hahahaha." I almost want to crack the algorithm just to say I did...but I don't think it would be of any use. Thanks anyway, Mark A. Matte P.S...But if anyone has any ideas...the analyst/geek in me still sees it as a challenge. >From: "Gary Kjos" <garykjos 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 13:56:42 -0500 > >Here's a place that says they do Bluebird/imageABLE conversions... > >http://www.csc-papers.com/servicepages/legacyconversions.htm > >Perhaps it could be a fall back plan to send to them anyway... > >GK > >On 3/21/07, Mark A Matte <markamatte at hotmail.com> wrote: > > Blue Bird...and the product was imageABLE. > > > > I did track down an employee...wrote some of the app...but he hasn't > > returned my calls. > > > > The DB is INFORMIX...and there is a tool in the app that will convert >the > > OBJID back to a date time...but only 1 at a time...and I have over 5 > > million. > > > > > > >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 08:58:07 -0700 > > > > > >What's the company name? Maybe somebody knows someone who worked >there (I > > >just tracked down an former employee of a defunct company). > > > > > >Also how do you know that the 8 character keys are date/time? > > > > > >What's the platform of the db? Access? > > > > > >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 8:49 AM > > >To: accessd at databaseadvisors.com > > >Subject: [AccessD] OT(kinda): Crack Code > > > > > >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 > > > > > >_________________________________________________________________ > > >Its tax season, make sure to follow these few simple tips > > > >http://articles.moneycentral.msn.com/Taxes/PreparationTips/PreparationTips.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 > > > > _________________________________________________________________ > > 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 > > > > > > >-- >Gary Kjos >garykjos at gmail.com >-- >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/