Change Or Modify Currency With Symbols In MS Office Accounting Express 2009

Change Or Modify Currency With Symbols In MS Office Accounting Express or Professional | Computer Tips And Tricks, Gadgets, How-To, Life - 2.0 Style:

Method 2:

You have to edit or modify the base currency directly into SQL Server database so that it will be easily reflecting to the fresh preferred currency. Microsoft Office Accounting stores the data into the SQL Server.

To apply this setting, execute the “SQL Server Studio”. It should be installed in the system separately. Now, connect to the database engine namely MSSMLBIZ.

Select the “New Query” option from the toolbar. Now select the database of the specific company for which you have to modify the currency. Enter the following SQL into the New Query window:

update CurrencyTable set IsoCode=”XXX“, Symbol=”Y” where supportingTableId=79

You should replace the “XXX” with your definite currency code of the 3 letters. Replace Y with your preferred currency symbol. Now, run the SQL statement and the change will take effect.