Accountant Forums


Reply
Thread Tools

Money's database format

 
 
Steve Hanson
Guest
Posts: n/a
Thanked:
 
      10-08-2004, 01:53 AM
I decided to tool around with my old Money files in a binary editor
(can't do much else with them). The first thing in the file's header
was "MSISAM Database"--this is not news, the newsgroup FAQ states
this.

Well I noticed that in a similar position in an Access database I had
lying around it says "Standard Jet DB", so I replaced "MSISAM
Database" with that. I saved it and now Access didn't complain about
unknown database type, but it did request a password--which just means
they changed a tiny bit of stuff so that it wouldn't read straight
into Access. I ran an Access recovery tool on it and, sure enough,
could see most of my financial data in one of dozens of normalized
tables. No wonder Money is so slow.
 
Reply With Quote
 
 
 
 
johnbusc@hotmail.com
Guest
Posts: n/a
Thanked:
 
      10-08-2004, 02:09 AM
LOL

Hey, let's start over with the Money app!

JB


Steve Hanson wrote:
> I decided to tool around with my old Money files in a binary editor
> (can't do much else with them). The first thing in the file's header
> was "MSISAM Database"--this is not news, the newsgroup FAQ states
> this.
>
> Well I noticed that in a similar position in an Access database I had
> lying around it says "Standard Jet DB", so I replaced "MSISAM
> Database" with that. I saved it and now Access didn't complain about
> unknown database type, but it did request a password--which just

means
> they changed a tiny bit of stuff so that it wouldn't read straight
> into Access. I ran an Access recovery tool on it and, sure enough,
> could see most of my financial data in one of dozens of normalized
> tables. No wonder Money is so slow.


 
Reply With Quote
 
 
 
 
Guest
Posts: n/a
Thanked:
 
      10-08-2004, 02:19 AM
I don't think that using a database format for the file
would make it slower, I believe that they are slowly
integrating the internet connectivity throughout the
application. With the latest version, they now have
replaced the Money Express with MSN Alerts. This really
ranks.
>-----Original Message-----
>I decided to tool around with my old Money files in a

binary editor
>(can't do much else with them). The first thing in the

file's header
>was "MSISAM Database"--this is not news, the newsgroup

FAQ states
>this.
>
>Well I noticed that in a similar position in an Access

database I had
>lying around it says "Standard Jet DB", so I

replaced "MSISAM
>Database" with that. I saved it and now Access didn't

complain about
>unknown database type, but it did request a password--

which just means
>they changed a tiny bit of stuff so that it wouldn't

read straight
>into Access. I ran an Access recovery tool on it and,

sure enough,
>could see most of my financial data in one of dozens of

normalized
>tables. No wonder Money is so slow.
>.
>

 
Reply With Quote
 
Steve Hanson
Guest
Posts: n/a
Thanked:
 
      10-08-2004, 02:30 AM
<> wrote in
<03ed01c4acdd$360ae4d0$>:

>I don't think that using a database format for the file
>would make it slower, I believe that they are slowly
>integrating the internet connectivity throughout the
>application. With the latest version, they now have
>replaced the Money Express with MSN Alerts. This really
>ranks.


Jet is not a high performance database engine. This is why Microsoft
recommends people archive data--because Jet can't hack it. I agree
that some of the slowness is the crap IE interface and the constant
need to report to Microsoft's servers. However compare Quicken's
speed, which is way way faster than Money at displaying information,
doing searches, etc. That's where the database performance comes into
play.
 
Reply With Quote
 
Retired Coal Miner
Guest
Posts: n/a
Thanked:
 
      10-08-2004, 12:11 PM
What was the year of the old Money file on which you tried this?

Steve Hanson wrote:
> I decided to tool around with my old Money files in a binary editor
> (can't do much else with them). The first thing in the file's header
> was "MSISAM Database"--this is not news, the newsgroup FAQ states
> this.
>
> Well I noticed that in a similar position in an Access database I had
> lying around it says "Standard Jet DB", so I replaced "MSISAM
> Database" with that. I saved it and now Access didn't complain about
> unknown database type, but it did request a password--which just means
> they changed a tiny bit of stuff so that it wouldn't read straight
> into Access. I ran an Access recovery tool on it and, sure enough,
> could see most of my financial data in one of dozens of normalized
> tables. No wonder Money is so slow.


 
Reply With Quote
 
Steve Hanson
Guest
Posts: n/a
Thanked:
 
      10-08-2004, 03:05 PM
Retired Coal Miner wrote in <IIadnXGGH_-aGfvcRVn->:

>What was the year of the old Money file on which you tried this?


2002 and 2005. One table I noticed was called "Feature Expiration
Custom Pool". It was empty but had a number of fields.

I spent all of about 30 min. poking around, using some freeware tools.
I'm sure someone with more time and interest, i.e. a Money user who
knows a little about databases and programming, could find interesting
ways to hack Money's data file. There are many possibilities. I
personally just don't have the time or inclination since I'm no longer
a Money user.
 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Quicken database format? Stubby Quicken 5 12-10-2009 09:59 PM
Tax ID Format Changes to SSN Format spenceman1013@gmail.com Quickbooks 3 01-31-2007 04:37 PM
Quicken database format? William W. Plummer Quicken 0 01-31-2005 10:17 PM
What database format is used in Money Jose Luis Microsoft Money 8 11-22-2004 04:25 AM
Conversion from .csv format to .qif format Dave Microsoft Money 2 07-21-2004 02:10 AM


All times are GMT. The time now is 12:31 AM.
Posts in this forum do not constitute the advice of AccountantForums.com or its members. Financial advice should always be taken from qualified advisors before committing to a financial decision.