Error Code 0x0000045a

[Multiroof]

Hi Everyone,

I was using Money UK version fine 2005 I think until it decided to come up with an error code "We were unable to load a required library autoupdate.dll Error Code 0x0000045a"

Anybody please have any ideas on this can be resolved.

I'm on Windows 11.

Thank you.

[joe dempsey]

Can you explain a bit more about when the error code comes up?

[Multiroof]

Yes the code comes up as soon as I try to run the programme.

[Bill & Michelle Becker]

The only mention of this error I could find is here:

http://moneymvps.org/faq/article/440.aspx

It's really old and Windows 11 no longer has Internet Explorer, although it does have the components of IE that Money uses.  But there is a way to reset the network adapter in Windows 11:

https://www.windowscentral.com/how-manage-network-adapter-settings-windows-11#reset_network_adapter_windows11

It might be worth a try.  I don't think it will do any harm, but if there are any Windows 11 gurus out there, please advise.

Bill Becker

--
You received this message because you are subscribed to the Google Groups "Microsoft Money" group.
To unsubscribe from this group and stop receiving emails from it, send an email to microsoft-mon...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/microsoft-money/9b253eb5-9637-4ed3-af68-f74f4172ced1n%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Multiroof]

Thank you for investigating this. This problem only occured with the latest Windows 11 feature update. (I'll supply exact name when I get back to the affected computer). For the time being, I've unrolled this update and after reinstalling Money, it works fine.

Perhaps I'll install the windows update again and try resetting the network adapter. 

[joe dempsey]

You could try the Compatability troubleshooter and setup Money to run as a Windows 10 or earlier programme

[Multiroof]

I had installed the Windows 11, version 22H2 which I believe is due for release later this year. As this is an evaluation version perhaps these issues haven't been ironed out as of yet. But it will be worrying if a radical fix is going to be required.

[Troels Bjerre]

That would be build 22581? No problems with that build here. You must have some other problem. Did you try reinstalling Money?

[Multiroof]

I uninstalled the entire 22581 windows 11 update and reinstalled it. At the moment Money appears to be working fine and I assume something went wrong with the first install.

[Tom Roberts]

Am wondering if there is any way to look into a money file to see what past exchange rates I used for currencies. Any suggestions ?

[Dick Watson]

(Not clear why the subject and Google Groups threading do not seem to have made this its own new thread.)

I don't think I can give you a definitive answer; what follows is somewhat from my nether regions as I have not played much with non-default currencies in Money.

Money support for non-default currencies always seemed to be somewhat of an afterthought bodge. Even finding what currencies it supports is obscure: Tools | Settings | Program settings | Currency | Update currencies is the only way I know of to see, via the UI, much of anything to do with exchange rates. And it only shows the most recent cross rate to the file default currency. They certainly don't expose it in the UI, like, say, they do with investment price/quote history, even though they are analogous, in any way I'm aware of. I won't be shocked if somebody chimes in to prove me wrong (please do!!!), but I'll bet the path they know to get at it from the UI is pretty obscure.

The only other way I know of involves under-the-covers hackery using tools like @hleofxquotes Sunriise tools for extracting the .MNY to .MDB (which, in turn, require Java and use the Health Market Science tools for getting into the closed Money database files). Once past that hurdle, my Money Reverse Engineering (Google: MS Money reverse engineering) tools can be used to get at some of this stuff in the resulting.MDB file in more useful--joined relationships--ways. Although I'm pretty sure I have done some of the reverse engineering to figure out the Money schema for exchange rate information, documented that knowledge in the MRE database, and have some queries that deal with extracting exchange rate history, I'm travelling and do not have ready access to all of that stuff to say for sure.

So, it comes down to how badly you need/want to get at this information. It can be done, more or less. Hackery and some Java, database, and MS Access knowledge will be required. It's not a thing for the faint of heart.

[Ameridan (microsoftmoneyoffline.wordpress.com)]

Tom,

If you want a historical record of exchange rates, add it to your investments either by adding directly [Portfolio - Update Prices - Pick Quotes to Download] and use MSMoneyQuotes to update (or simply add manually), or adding it to the stocks section of your sites.dat file for Pocketsense [example: USDJPY=X        #USD to Japanese Yen].  You'll be able to see Price History chart, just like any other investment.

On Tuesday, April 12, 2022 at 5:53:17 AM UTC-5 Tom Roberts wrote:

[Dick Watson]

To be clear, or perhaps so I'm clear, you are suggesting using a faked "investment" to track currency exchange rates, not something that integrates with the exchange rates embedded in cross-currency account cash transactions (e.g., transfer from, say, a USD account to a JPY account that starts in Dollars and ends in Yen and implies an exchange rate), right? (IIRC, one can also enter a one-time exchange rate in a single income/expense transaction with F8 but I don't recall the semantics of how this is stored; I'm thinking that nothing about the fact that you used this method to create the transaction is actually saved, so the account-specific currency and amount lives on but the fact you started with a foreign currency and applied and exchange rate is not stored.)

[joe dempsey]

Yes, that's what Ameridan is proposing

Although Money does update the exchange rate, I am not sure that it keeps a history of exchange rates - they certainly are not available

[Ameridan (microsoftmoneyoffline.wordpress.com)]

That is correct.  I have quite a few fake investments in my "Notes" watch account that display in my Portfolio screens, complete with memo details and "price" history.
The process is described @ https://microsoftmoneyoffline.wordpress.com/2015/08/24/keeping-track-of-your-fico-scores/

[First Last]

As mentioned by Dick, you can use sunriise to examine the low-level CRNC_EXCHG (not for the faint of heart ;-))

In above example, 1st row said

On Aug 17, 2002, the exchange rate for currency 44 to 4 is 40.34

44 is Euro (EUR)

4 is Belgian franc (BEL)

I have a tool to export the content of above tables into CVS BUT I did not do the Exchange rate. I will be happy to include Exchange rate if you think it will be useful for you.

You can try out the export tool, see this write-up

https://bitbucket.org/hleofxquotesteam/dist-sunriise/wiki/Home

Best,

--

You received this message because you are subscribed to the Google Groups "Microsoft Money" group.
To unsubscribe from this group and stop receiving emails from it, send an email to microsoft-mon...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/microsoft-money/26cd2e86-54d8-4e4d-9ce6-75df2299cb47n%40googlegroups.com.

[First Last]

I meant to also include a sample CRNC table

[Tom Roberts]

This is all quite interesting and I'm going to now begin reviewing. Really appreciate your responses and am awed by your commitment to MS Money.

Give me a bit more time and I'll come back more fully. Have had other priorities recently.

To view this discussion on the web visit https://groups.google.com/d/msgid/microsoft-money/CAG4rfmMTei_w9mw8wyWaqc8JXkPwV1dRttu66UYsk%2BS3ZmtmXg%40mail.gmail.com.

[Tom Roberts]

Hi Ameridan - i use msmoneyquotes. but what would be the ticker to add for rates for CAD/USD, CAD/GBP, CAR/EUR. 

--

You received this message because you are subscribed to the Google Groups "Microsoft Money" group.
To unsubscribe from this group and stop receiving emails from it, send an email to microsoft-mon...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/microsoft-money/b3099428-6422-4b98-8105-ae2e59c2f384n%40googlegroups.com.

[Ameridan (microsoftmoneyoffline.wordpress.com)]

The exchange rates at Yahoo that I am familiar with are at: https://finance.yahoo.com/currencies#flat-rates 

Does Yahoo have a Canadian site?

[joe dempsey]

I downloaded the Account viewer but I get an error message when I execute it

I have installed the Java Runtime Environment from www.java.com - it is version 8 update 321

When I run the Account Viewer , I get the following error message

Exception in thread "main" java.lang.UnsupportedClassVersionError: com/hungle/sunriise/accountviewer/AccountViewer has been compiled by a more recent version of the Java Runtime (class file version 55.0),

this version of the Java Runtime only recognizes class file versions up to 52.0

Any ideas of how to proceed from here?

Thanks,

Joe

[joe dempsey]

Solved - I downloaded the JDK from Oracle (Version 18) - everything is working now

[Tom Roberts]

OK, I found it. Thanks

I can create a ticker for the exchange rate and put it into a separate account and purchased 1 unit at 1 unit price. This is useful.

The thing I am most wanting to do is know when I have updated an exchange rate in the currencies section.  

 

[Tom Roberts]

thx for posting.

The same sequence worked for me as well.

To view this discussion on the web visit https://groups.google.com/d/msgid/microsoft-money/e9789a3c-9353-4db0-bead-02ac85d81320n%40googlegroups.com.

[Jonathan Casiot]

I don't know if this would be at all useful but msmquote can update the exchange rates in MS Money and the updated rate is written to the log output.

Regards,

Jonathan.

To view this discussion on the web visit https://groups.google.com/d/msgid/microsoft-money/CAEDzrA_vgUt3J3W%3DVoY7SUzo_ygFb%2Bg07O62bJs45nu1Kyc79Q%40mail.gmail.com.

[First Last]

I don't use multi-currency account so I never have to deal with exchange rate directly in msmoney.

My gut feel is that each transaction would have the currency rate exchange embedded but I don't have an example to verify. So if what you are really looking for is that fact. For transaction XYZ what exchange rate was used, the next best path is to create a sample mny file for me. Give me some background: like an account ABC using USD and EUR and on this date I create a transaction that uses the exchange rate. Send me a copy and I can try to see if I can pull such information out for you.

I did some quick search to get some background on msmoney multi-currency/exchange rate handling and found this one (Dick did some interesting investigative work ...)

https://www.accountantforums.com/threads/how-do-i-change-currency-exchange-rates.88476/

[Jonathan Casiot]

The way Money uses exchange rates is pretty straightforward. There are two methods that I've encountered:

1. A transfer between accounts with different currencies. Here the user is prompted for the FX rate that they wish to use and one can either use the current rate that Money has stored or enter an alternative rate. Money stores transfers as two transactions internally: a debit from one account with a credit to another. No exchange rate is stored in this case: it is implicit in the debit and credit amounts.

2. An investment transaction in an account that is not in the base currency, credited to, or debited from, an account that is in the same currency as the investment account. Again the user is prompted for an FX rate and again two transactions are stored internally but this time Money does also record the corresponding base currency amount in the two transaction records. This recorded base currency amount can be subsequently changed by right-clicking on the transaction in the investment account and then selecting Enter Exchange Rate.

Regards,

Jonathan
msmquote - an open source security and currency exchange rate quote updater for Microsoft Money.

To view this discussion on the web visit https://groups.google.com/d/msgid/microsoft-money/CAG4rfmOO7hwS0LdFTkCRZGomW2_AHSTj3rYUAwCCe0Sp%3Dmu4XA%40mail.gmail.com.

[Dick Watson]

A third method is FX-assisted amount entry in any cash account register. When entering an amount, you can hit F8 (or it’s on the r-click context menu pop-up) and get an instant exchange calculator. It offers up rates it knows and you can enter your own. My recollection, I’ll look into at first opportunity, is that this is only a UI thing, and the original currency amount and exchange rate are not stored with the transaction, and not recoverable in the future only the resulting account currency converted amount is stored.

I’d been forgetting about the whole morass of how Money treats exchanges between cash account in one currency and investments valued in another. It appears I knew way more about this in 2009 than I remember in 2022.

On Monday, April 18, 2022 at 2:41:08 PM UTC-5 jona...@pueblo.co.uk wrote:

The way Money uses exchange rates is pretty straightforward. There are two methods that I've encountered:

…

 

Jonathan

msmquote - an open source security and currency exchange rate quote updater for Microsoft Money.

On 18/04/2022 18:51, First Last wrote:

… 

I did some quick search to get some background on msmoney multi-currency/exchange rate handling and found this one (Dick did some interesting investigative work ...)

https://www.accountantforums.com/threads/how-do-i-change-currency-exchange-rates.88476/

[Jonathan Casiot]

Yes, it is just a UI feature, the original currency amount isn't stored by Money. I use the memo field to keep track of that if I need to.

Jonathan
msmquote - an open source security and currency exchange rate quote updater for Microsoft Money.

--

You received this message because you are subscribed to the Google Groups "Microsoft Money" group.
To unsubscribe from this group and stop receiving emails from it, send an email to microsoft-mon...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/microsoft-money/06f2ad3c-f173-4b69-9914-941291ce032cn%40googlegroups.com.

[Dick Watson]

FWIW, I went spelunking in CRNC_EXCHG in my real Money file.

It has transactions from 1993 onward, and was exposed to MSN updates as long as they were a thing. It has multiple cash account transfer transactions between [USD<->JPY] and [USD<->EUR] accounts. It does not have any of the "F8" exchanges, iIRC, because I figured out pretty quickly that this was no better, and more troublesome, than just putting in the amount in account-native currency. (So I could reconcile international travel, I created JPY cash and EUR cash accounts to enter all the transactions as they happened and then use transfers in/out from relevant USD accounts to accommodate the exchange rates.) I've never had any foreign denominated Investments. With that background, my CRNC_EXCHG table has only one rate for any exchange pair (the latest from ???). All the dates (column dt) are set to Money's nil date constant except for the European currencies to EUR which have a dt of 8/24/1999. (Speculating, but too lazy to look, that this was the Euro cutover date. And more speculating is that for some reason MS forced these values into the table for historic/accounting reasons for those affected by the Euro transition.)

I made almost no notes in my data dictionary regarding the CURR And CURR_EXCHG tables. But they are pretty simple.

I suspect that the testcase data file Tom Roberts created can answer the remaining questions that come to my mind: does Money update the apparently singular stored rate for any/most recent transaction entered (via F8 or cross-currency transfer) that has a user supplied rate? Or, was MSN update the only way these got updated?

In my semi-imaginary Money replacement schema/design, a currency exchange is semantically treated no different than an investment<->cash exchange. All value is held in tokens. (A dollar, or a Euro, or a share of Tesla; all just tokens of value.) So, an investment price history dataset (e.g., USD<->TSLA share via transactions or market data) is no different under the covers than a given FX exchange rate history dataset (e.g., USD<->EUR via transactions or market data). I can't claim it as an original thought; GNUcash, IIRC, was designed this way.

If you want to have a history of exchange rates implicitly captured in transfer transactions that begin with one hcrnc and end with another, you'd have to go the full monty of joining the transfer transaction elements and then where the hcrnc did not match from side to side. I could probably figure it out, or bolt it onto queries I'm already pretty comfortable with, but I can't air-code it. (I may have already solved this or taken a swing at it. Can't remember how far my schema gets at this.)