Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #4  
Old 10-08-2004, 03:05 PM
Steve Hanson
Guest
 
Posts: n/a
Default Re: Money's database format

Retired Coal Miner wrote in <IIadnXGGH_-aGfvcRVn-vQ[at]comcast.com> :

- quote -

> 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.
  #3  
Old 10-08-2004, 12:11 PM
Retired Coal Miner
Guest
 
Posts: n/a
Default Re: Money's database format

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

Steve Hanson wrote:
- quote -

> 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.


  #2  
Old 10-08-2004, 02:30 AM
Steve Hanson
Guest
 
Posts: n/a
Default Re: Money's database format

<anonymous[at]discussions.microsoft.com> wrote in
<03ed01c4acdd$360ae4d0$a501280a[at]phx.gbl> :

- quote -

> 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.
  #1  
Old 10-08-2004, 02:19 AM
Guest
 
Posts: n/a
Default Money's database format

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.
- quote -

> -----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.
> .

 
Old 10-08-2004, 02:09 AM
johnbusc@hotmail.com
Guest
 
Posts: n/a
Default Re: Money's database format

LOL

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

JB


Steve Hanson wrote:
- quote -

> 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.


  #-1  
Old 10-08-2004, 01:53 AM
Steve Hanson
Guest
 
Posts: n/a
Default Money's database format

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.
 

Tags
database, format, money
Similar Threads
Thread Forum Replies Last Post
Conversion from .csv format to .qif format
Dave: I am unable to get our brokerage firm to give downloads in .qif or web connect - but they can and do give downloads in excel .csv format. It seems...
Microsoft Money 2 07-21-2004 02:10 AM
Cannot Save to Money Database File
John Pasula: Hello everyone, everytime I try to make a change to my money database file, it tells me that it's in use by another application. I have a feeling...
Microsoft Money 10 11-03-2003 05:17 AM
Money & Jet Database Engine
Frank: I've been told that Money utilizes the Jet Database Engine to maintain its records. Over time I've experienced various difficulties with the My...
Microsoft Money 2 07-30-2003 02:54 PM



Thread Tools
Display Modes

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 Off
Refbacks are Off

All times are GMT. The time now is 11:10 PM.