Re: What database format is used in Money by Dick
Dick
Sun Nov 21 18:53:14 CST 2004
I'm no OLE expert, but all of the heavy lifting of MoneyLink appears to be
done by the USMNY type library. All the juicy stuff gets done by invoking
some of its interfaces. (BTW, MoneyLink appears to also use some Money
interfaces. Regardless of the level of Money data file you are trying to
open, MoneyLink blows up if that version of Money is not locally installed
as well.) Without getting into that, what can we do that's Jet like? What
are the "slight [modifications]"?
I agree we could easily get at M98/99. (Though what you could do from there
remained subject to lots of hacking to figure out the database that never
really got done.) What's the interface we can use to get at M02/3/4/5 in
similar manner? You say it's pretty easy to look at the database; but how do
we get at things that MoneyLink doesn't expose? (E.g., the Investment list,
the Banks list, the Payees list, the Scheduled bills, etc.) I'm certainly
open to new information. There are several shortcomings of MoneyLink I'd
love to get around--some minor ones I could probably do by hacking their
VBA, but barring a better understanding of USMNY or some way to replace it,
I haven't messed with it. Maybe cracking this thing open needs to be a
community effort?
Barring that, I think we are in rough agreement. MSISAM is certainly a Jet
derivative. It's not opened up like Jet to the rest of us.
"Ed Hansberry, MS-MVP/Mobile Devices"
<spamfree-silvernino@hotmail.spambegone.com> wrote in message
news:2cb2q05tjs3bcjvtmh5cnc06liis6is0i6@4ax.com...
> "Dick Watson" <littlegreengecko@mind-enufalready-spring.com> wrote:
>
>>MSISAM certainly appears similar to Jet. It seems pretty tightly closed,
>>however.
>
> No - it is Jet. It is just slightly modified and password protected.
> Money 98, the first version, was directly accessible from Access and
> calls to Jet libraries. I've looked at it via the MoneyLink addin.
> Oddly enough, the addin for MOney 2005 isn't password protected, or
> wasn't (they may have changed the download from a few weeks ago) and
> it is pretty easy to look at the database.