SQL Server

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Money
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - Easiest way to verify if MS Money has the latest update Using Money 2005 Small Business What is the sure but easiest way to verify if MS Money has the latest update? TIA Dennis Tag: SQL Server Tag: 182473
  - 2
    - Money 2005 trying to convert files twice I downloaded the Money 2005 trial and it converted my files and everything seemed to work fine. So I went out and bought 2005 Premium. Now, I've installed 2005 Premium and it insists on trying to convert the converted files and then fails miserably. any hints? Tag: SQL Server Tag: 182472
  - 3
    - Payee name variation While trying to fix a problem I find myself going through my list of Payee name variations and I find entries like: Check 2295 trace #2411538 Check 2296 trace #2411542 Check 2297 trace #2411551 And then an associated Payee. Is there any way to have Money 2005 exclude entries like this? Tag: SQL Server Tag: 182464
  - 4
    - Report "Spending by Category" reflects charges but not credits MS Money 2005 Successfully uploaded two years data. While enjoying the pie chart graphs, I noticed that "Gifts" (expenditures) reflected all charges from my credit card (for Gifts) but did not reflect the return and credit received. For example: Gift Expense CAMERA Purchase $299.95 Gift Expense Camera Return ($299.95) Net "Gift Expense" -0- If I look at the Pie Chart (and underlying details) "Gift Expense" is $299.95 -but- If I go through Banking>Categories>Detail Transactions I see the Charge AND the Credit. This is correcct! In short, it appears that the Pie Chart is factory-setup to look at only charges (debits) to "Gifts"? Is there a way to correct the chart reporting? TIA Dennis Tag: SQL Server Tag: 182457
  - 5
    - Balance on Account List does not match balance if I view all transactions Recently MS Money 2004 seems to have flaked and executed some Bills and Deposits for 2005 and caused my account balance on the account list to not be correct. If I view the account the balance was also incorrect if I only viewed unreconciled transactions. After reading http://support.microsoft.com/kb/838713 Methods 1 and 2 did not fix the problem. I then exported the information into a loose QIF file and read it. It appears eight transcations were automatically executed for their next dates in 2005. They did not show up in the account but I could see them if I chose "Go to Payee:" from the Bills and Deposits screens. I could then void each of the transactions so their amounts would be zero. Just curious if anyone else experienced this. I have been using Money for about a year. MS does not really explain why it occurs. Tag: SQL Server Tag: 182456
  - 6
    - Microsoft Office Small Business Accounting Beta (Money on Steroids?) New competition for QuickBooks. Integrates with Microsoft Office 2003, including new version of Outlook 2003. Who knows, maybe Outlook integration will eventually trickle down to Money, but then again, maybe not. More at http://snipurl.com/b9vm. Used SnipURL because "http://www.microsoft.com/office/editions/prodinfo/ smallbusiness/accounting/default.mspx" is too unwieldy for newsgroup use. -- Brent Neville Tag: SQL Server Tag: 182451
  - 7
    - Problems When i try and log onto Money deluxe 2004 it requires me to get online everytime - there used to be a button that let me skup that option, but now it is gone. I heard you have to download something to fix that but dont know where to go. I also always press "remember my passwords" but everytime i have to enter it. Is this part of the same problem or a different one? I have never been here before so i am sure these will be very simple questions to some of you but i am grateful for your time and would really appreciate any help. thanks again. Matthew - skyvend@aol.com Tag: SQL Server Tag: 182450
  - 8
    - Handling puchases, transfers, & cash advances on same credit card What is the best way to handle credit card â??special offer balance transfersâ?? in Money 2002 Deluxe? Some credit cards will split your monthly payments so that 70% of the payment goes to the lower interest rated balance first, and apply 30% to the higher interest purchases. Is there a way to project how much interest will be paid out with this scenario? Should I set up multiple accounts for the same credit card? Thank you! Tag: SQL Server Tag: 182447
  - 9
    - new user login problem using existing Money file. I moved my home computers to a Windows domain with domain-based logins. Previously, I accessed a Money 2003 file on the server from a machine-specific login. Now, when I open that file under my Domain login (and it does open fine, no permissions problems) I can't see my accounts, transactions, etc. (Thank God I didn't nuke that machine account!) When I return to the machine account, everything's still there. How can access the existing data from the new account login? Thanks in advance. Tag: SQL Server Tag: 182445
  - 10
    - Update Quotes Is there any way to permanently disable the "Update Quotes" feature? I do not have a stock portfolio and the Update Quotes feature takes upwards of 5 minutes to complete. I know that I can turn it off for each session, but I would rather just permanently disable it. Tag: SQL Server Tag: 182437
  - 11
    - IMPORT OF OFC IN MONEY 2005? Where is the IMPORT OF OFC IN MONEY 2005? Tag: SQL Server Tag: 182416
  - 12
    - Anyone able to get Ameritrade stocks purchases to update in their portfolio I'm sure I've seen this problem before and I can't remember what the fix is. (don't trade that often). Anyway seems that my downloaded stock transactions from Ameritrade don't seem to get updated prices online. I'm using money 2004 if that makes any difference, any advice would be appreciated. TIA, Brian Tag: SQL Server Tag: 182415
  - 13
    - WHEN WILL MICROSOFT PUT THE IMPORT OF OFC? IT IS AN absurd HAVE SO MANY COMPLAINTS AND HER SIMPLY TO IGNORE THE USERS Tag: SQL Server Tag: 182414
  - 14
    - Can we disable TAX option in money? I am staying UAE, donot have taxs on income. I want to use money 2005. i want to disable tax option is it possible.? Tag: SQL Server Tag: 182412
  - 15
    - money - start again i want to start again, so how can i remove all figures & hve a nill balance to start over for the new year?? Tag: SQL Server Tag: 182410
  - 16
    - Currency Exchange rates do not update! Following the last M05 major update, I noticed that the currency echange rates do NOT update online (automatically) anymore. If one goes onto settings / currencies, their is a check box for online update - but it does not seem to work. Any advice? Tag: SQL Server Tag: 182409
  - 17
    - Matching a transaction to Multiple Hi All, I was wondering if anyone has figured out a solution to this one... I go the bank and deposit a few checks. At home, I record each of the checks because their from different sources/categories, etc. Money downloads a lump sum desposit from the bank and now I try to match to the different transactions. I match them up, and accept them all and so far so good. Until I try to update the accounts again, and the lump sum shows up again. Any idea how to get Money to realize that it downloaded that transaction already and I accepted it? BTW I'm using Money 2005, but have had this problem for many versions. Thanks. -David Tag: SQL Server Tag: 182406
  - 18
    - Strange problem I buy my gas at Arco. When I enter Arco as the payee (or of it is placed there by Money, because it is in the payee list) Money 2005 crashes. If I use Arco Gas everything is fine. I tried deleting the Payee Arco and recreating it, but it still crashes. Any thoughts on this one? Tag: SQL Server Tag: 182403
  - 19
    - Problems Balancing Checking Account-Wrong Opening Balance or date range I have not previously had problems balancing my checking account wis Money 2004. Tonight when I went to do so, it gave a much different opening balance then the closing balance from the previous bank statement, when it balanced o.k. In fact, for some unknown reason, it was a month behind, said it wanted to balance the statement of 10/31/04...which I dutifully did again, after correcting the opening balance. That opening balance did not match any enf of month balances, even though eveyrthing balanced o.k. previously on 10/31/04. (This might be part of where things went wrong). Then when I balanced 11/30/04 statement, it told me my starting balance was incorrect, and that my account balance was off by 702.04. When I accepted the suggestion to make an adjusment of this amount it did it twice. One debit of 702.04 which it called "Starting Balance Adjustment" and 1 credit of the same amount which it called account adjustment, but both were dated 11/30/04, even though the starting balance adjustment should have applied to the balance as of 11/1/04. Of course these two bogus entries cancel each out. The net result as of the last entry on 11/30/04 was to agree with the bank statement, as it had the previous month, and maybe everything will be fine next month. But why did it tell me the starting balance was wrong, when it was satisfied with the same amount as the ending balance the month before? It appears to me that it was attempting to balance a statement beginning 11/30 and ending 11/30, and that perhaps it got confused about what the last statement date was on which the account was balanced. As I said, I know I had balanced the 10/31/04 statement previously, but when I began my balancing act tonight it insistred that was the date to it wanted balance, and the opening balance was all wrong. That seems to be where it got messed up. It did had RECONCILED all downloaded transactions after 11/30/04 up through 12/8/04, which never happened before again suggesting it was confused about what time period was being balanced. Any ideas what went wrong? And if I need to do something before next month to make sure no problems occur? Thanks for any help. Tag: SQL Server Tag: 182400
  - 20
    - unwanted internet auto disconnect For money 2004, after I update online, the program automatically disconnects the internet connection (56k dialup) which I dont want it to do if I am working on other programs. Is there a way to change the settings? Tag: SQL Server Tag: 182397
  - 21
    - How to get a check register report I want to get a check register report, showing credit totals versus debit totals, with none of this nonsense about categories and transfers for a two-year period. Can Money do this? Hollis D. Paul [MVP - Outlook] Hollis@outhousebythesound.com Using Virtual Access 4.52 build 277 (32-bit), Windows 2000 build 2600 http://search.support.microsoft.com/kb/c.asp?FR=0&SD=TECH&LN=EN-US Mukilteo, WA USA Tag: SQL Server Tag: 182391
  - 22
    - Restoring Files I had to restore my computer, when I went to restore my 2005 money file using my bu file it gave me a file protect error message. It is not write protected. I could not restore any money file copy I had that had been opened in money 2005, but I could restore a file used in 2004 money without any problem? Tag: SQL Server Tag: 182387
  - 23
    - Money crash on statement download Very recently, if I download a bank statement as I've done for years, I get an immediate "cannot read memory at address xxxx and Money shuts down. It also corrupts the data file and I have to delete the mny file, then open Money and restore a backup. Last night it made me go back to the sample file provided with the program in order to get rid of the memory exception shutting down the program as soon as it was started. Using OFX file download. Thanks for any help Tag: SQL Server Tag: 182386
  - 24
    - MS Money 2005 "Is Already Running" message I have Works Suite 2005 and run Money 2005 s part of it. I launch money seperately and not from withinn Works Suite 2005 and it launches ok. But when I close Money 2005 and then try to restart it it comes up with the message "Money is already running" and won't start up. The only way to get Money to restart is to reboot the PC. I have tried this on two different PC's (both run Win XP home with SP2 and get the same issue on both. I have been using Money for years and in Works Suite's 2003 and 2004 this has not been an issue Any suggestions to resolve this please. Tag: SQL Server Tag: 182379
  - 25
    - Home Inventory not added to asset list When I check mark "add home inventory to net worth" it doesn't show up on the asset list. Any solutions? Tag: SQL Server Tag: 182374
- Next
  - 1
    - Money 2005 Reports I use Money 2003 and am happy with it. However, I would like to see a report that shows year over year comparisons. By that I mean compare my expense categories for November 2004 against November 2003. I can't find out if that is one of the reports available in Money 2005. Do you happen to know if this type report is available? It would be my only reason to upgrade. Thanks, Mike Tag: SQL Server Tag: 182373
  - 2
    - Same day buy/sell It appears that downloaded sell transactions are being processed prior to buys transactions on the same day for the same security. This causes Money to add shares which put the account position out of balance buy the amount of the sell transaction. This requires the position to be corrected manually. Any chance of a fix? Tag: SQL Server Tag: 182363
  - 3
    - Imported but apparently not MSMoney 2005 Win XP I'm having a problem with the import feature. I downloaded an OFX file for all 3 accounts at my financial institution. I used File, Import and it asked me to confirm accounts 1 & 2 but not account number 3. The first two imported perfectly. I looked at the file and sure enough the details for account number 3 were in there. So then I exported account #3 only and tried importing it. It just comes up and says "import complete". I checked the first transaction in the file a meal at Pizza Hut and I can see it hasn't imported into any of the accounts in the "you have n statements to read" list. My total account balances is not changing so obviously nothing is being imported. Has anyone else experienced a problem like this? I assume that something exists in the file that MSMoney doesn't like so it is ignoring the whole file. Except for a file imported dialog box does MSMoney have any diagnostic log that can be turned on? Thanks in advance, Tim Tag: SQL Server Tag: 182360
  - 4
    - MONEY 2001 Online Service Problem When I try to access Tools>Online Service in Money 2001, I get the following errors: "Server name not recognized. OFXIE12007" "Unable to connect to Online Quotes Server" It used to work fine just recently. Can you confirm if MS has changed the Online Service server name to force people to upgrade? Tag: SQL Server Tag: 182357
  - 5
    - Account Setup Temporarily Unavailable OK I decide to wipe the slate clean on my 2005 trial and deleted my problematic account that was not showing current transactions. When I went to set it up it started buy has hit a glitch. The bank name is now appearing in my account list but is asking me to provide sign in information so I click that link and it takes me to the list of banking institutions and highlights mine. I click next and it gives me the error message, "Account Setup is temporarily unavailiable. Please try again later". This is gone on all day. I have another account listed in my list from a different institution that is updating fine. Seems strange. I went to msn. money and Yodlee to see if I could set them up there and both are working. Yodlee has perfect syncing....msn money is not downloading current transactions but current balance. Not sure what to think about all of this. Tag: SQL Server Tag: 182354
  - 6
    - Money 2004 PPC Continually Syncs with ActiveSync 3.71 I have a Dell Axim X5 (Mobile Pocket PC 2003) with Money 2004 PPC and ActiveSync 3.71. All of my money accounts syncronize perfectly when I sync up with ActiveSync on my PC. Once Active Sync has completed synchronizing my Pocket PC and PC, Money in Activesync still displays "1 file not synchronized" and continually tries to sync the file. The only way I can stop this from continually happening in Active Sync is to press the Stop button (the 1 file is still not synchronized)! Tag: SQL Server Tag: 182346
  - 7
    - Product confusion (cont.) Further question to my earlier post: Is this correct: MoneyCentral changed to MSN Money. Then Money changed from free, to a purchased product. The free version no longer supports downloads from brokers and many of the charting options. To get broker downloads and many charting options, I need to purchase Money 2005. Is that correct? PS: Cal, thanks for your earlier reply. -- Bill Tag: SQL Server Tag: 182338
  - 8
    - Money 2005 Duplicate Downloaded Transactions I finally got my Bank of America account transactions to download through online services. My only gripe is that old transactions which have already been downloaded on a previous day are being re-downloaded along with new transactions every time I perform an update (I do this once a day). When the old transactions are re-downloaded they are matched with existing transactions again and I have to re-accept the transactions. Should this be happening? I thought that Money's logic would prevent old transactions from being downloaded again or at least save me the trouble of having to accept and match them again. Also, shouldn't Money be getting the latest and greatest transactions from my bank(today's transactions preferably but at the very least yesterday's transactions)? It seems that my downloaded transactions only go up to 2 days ago. I know that Yodlee provides the direct services for Bank of America. Is this an issue with Yodlee? Thanks, Shawn Tag: SQL Server Tag: 182328
  - 9
    - Money 2005 Deluxe, MSN Money Sync and msmoney.exe process Have had two issues. When I exit Money, apparently it does not shut down the msmoney.exe process because when I go to restart the program, I get a small dialog box saying the program is already running. If I use task manager to kill the process, I can then start it. I do have Money set to back up on exit, and that seems to run fine, if that matters. The second, more troublesome was trying to use Money to sync with MSN Money on line. I ended up with very strange duplications of entries from 2003 on (hav history going back to 1996). I deleted everything on MSN Money, restored a back-up, tried again (twice.) Again, same thing. I have since discontinued trying to use this feature since the 2005 Money for Pocket PC is finally out, but all three be able to work together? Extremely frustrated with Microsofts online support, no help or helpful response. Have received COMPMAIL CASE ID confirmations several times for the second issue, and then follow-up emails with a managers email address, that is no good. -- David Tag: SQL Server Tag: 182327
  - 10
    - Product confusion I am confused. Several years ago I began using MoneyCentral to manage my investment portfolio. Then it changed to Money. I set up everything to download my investments from my brokers and fund managers. I used some of the nice carting features. A few days ago I logged on (after several months of inactivity). I can see my portfolio, but there appears to be no links to my brokers or fund managers, and the chart options are minimal. What happened? I cannot find anything in the knowledge base articles either. -- Bill Tag: SQL Server Tag: 182324
  - 11
    - Money:2005 I recently had to reinstall Money 2005. When I did so I can no longer open my mny file nor my backup file. Any suggestions? -- Rich Tag: SQL Server Tag: 182322
  - 12
    - Money 2005: Fidelity: Capital gains distribution appears as divide Hello, When I receive a capital gains distribution on a mututal fund on my fidelity account Microsoft money shows this in the account register and in the Portfolio as dividend. I do not have this problem with Etrade for example. Also it seems that Dividends from Fidelity sometimes come in later than the reinvestment-purchase and this causes Moeny to "add shares" which after the Dividend is registered leads to a "remove" shares so the total number of shares is equal with the number on the account. However that leads to confusion in the Portfolio manager which then does not show the cost basis correctly any more. What is wrong and how can I corect that? Is the problem perhaps with Fidelity? Thank you! - Kitechick Tag: SQL Server Tag: 182321
  - 13
    - Money 2004 Deluxe ->Money 2005 Standard Can I simply install 2005 Standard over 2004 Deluxe? I never use the extra features and the Standard was free. Tag: SQL Server Tag: 182313
  - 14
    - Money 2005 Can Be Updated Externally I don't know if this will add confusion or be of help to some, but FWIW, the recent Money 2005 update (not the 2004 to 2005 upgrade) was downloaded and installed when I visited MoneyCentral.MSN.com, as I regularly do for news, fyi, etc. on specific investments we hold. Apparently, the Web pages now share so much code (e.g. ActiveX Controls) with Money (msmoney.exe) that updating one inherently updates the other. Of course, I still had to go through the file conversion process the next time I opened each of our Money files. For anyone experiencing problems completing the update (software download and installation, not file conversion) when running Money (msmoney.exe), this may offer a possible solution. -- Brent Neville Tag: SQL Server Tag: 182312
  - 15
    - Two Desktop Computers Hello, I would like to be able to work on my Money file in two seperate locations, transferring the file back and forth on CD-R's to keep both synchronized. Would I need to purchase a second copy of Money 2005 or would the program allow a second install? Thanks in advance. Rick Tag: SQL Server Tag: 182311
  - 16
    - base currency The currency in Turkey will be changed next year by dividing the existant currency by 1.000.000. How can I divide the amount of all of my transactions by 1.000.000 ? Tag: SQL Server Tag: 182298
  - 17
    - Sync Problem MS Money --> PocketPC Hi, When MS Money for PocketPC on my new Dell Axim x50v tries to sync with my Money-file on the desktop PC (MS Money De Luxe 2004), Active Sync asks for a password. But when I write the password (plain letters) I use when I open MS Money on the desktop, Active Sync tells me that it isn't correct! Strange ... Any clues?? Thanks in advance, Peter from Sweden Tag: SQL Server Tag: 182295
  - 18
    - Money PPC 2005 Finally got it to install properly, but still not synching Payees and Catagories. What the......?? Tag: SQL Server Tag: 182294
  - 19
    - Bank Account AND Investment Account I have had several investment accounts at etrade for some time and been able to get online updates with no problem. I just added a bank account and am unable to set up the online services to pick up both the investment accounts AND the bank account. I can configure to update the bank account ONLY or the investment accounts ONLY, but NOT BOTH. When you sign up for online services it asks whether you are setting up a bank, credit, or investment account. When you select one, you must be setting a flag because that is it. It will only retrieve the data for that type of account. Then, once the online services are configured, you cannot add a different type of account. Anybody know a workaround? This is a royal pain. Thanks, jc Tag: SQL Server Tag: 182292
  - 20
    - Unable to login using passport to MS Money 2005. I reinstalled my OS. Previously I has Money 2004. With the new OS, I installed Money 2005 and opened my existing money file. I always get login failed. If I create a new money file, my passport works. Regards, Xavier Tag: SQL Server Tag: 182291
  - 21
    - Money Manual It seems to me that there is a lot of functionality in this program that could be used if one had the knowledge. Is there any book on Microsoft that covers more than just the basics. For example creating custom reports by category and comments, or How to get your mortgage payment to match the amounts of principal and interest the way your bank says it is instead of MSMoney's calculated split. Thanks, Jack Tag: SQL Server Tag: 182290
  - 22
    - ? I have a bank account in ?, how can I setup this currency as default currency in the file? TIA Stefano Tag: SQL Server Tag: 182287
  - 23
    - Print all accounts contact details and balance summary Is there a way I can extract and print all my accounts balance and account contact details. In Quicken, this was a standard report. I find this useful as I travel a lot and god forbid but if something were to happen to me, my spouse should know about my account balances and who to call to manage accounts. Thanks - Manish Tag: SQL Server Tag: 182285
  - 24
    - Hide securities/investments On main view, under Investment Summary, there is an investment which hasn't had any transactions since 2002. Is there anyway I can hide it? Tag: SQL Server Tag: 182281
  - 25
    - Budget report I have income that is retirement income. The category assigned is recognized by the monthly reports and they correctly show this as income. My problem is the budget report. It will not identify and show this category as income despite a lot of trying. How do I get this to pick up on the budget report? The frustrating thing is that it shows in the monthly reports. I have checked and I show this category in my budget definition. Ideas or help? Tag: SQL Server Tag: 182278

Can MS money [specifically small business] be made to work with SQL Server?
Please advise.
--
New to ISA

Re: SQL Server by Chris

Chris
Sat Dec 11 10:19:50 CST 2004

No. To preempt your next question, there's no API at all.
--
Chris Cowles,
Gainesville, FL

"Maurice" <Maurice@discussions.microsoft.com> wrote in message
news:80C9B62E-8A59-4561-8952-4315E0F5E877@microsoft.com...
> Can MS money [specifically small business] be made to work with SQL
> Server?
> Please advise.
> --
> New to ISA

Top