If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
"Rewrite" an application without affecting old calculations
Hi,
I would like to ask advice on updating, rewriting an application database file. I created an application (1 file accde includes tables) that keeps track of the works of a rental shop. It consist of tables where different data is stored and it has forms where a user can input data then it has queries that calculate rental prices and finally it has reports that print invoices. It works well. But The rental shop wants to change the way they calculate the prices. I can easily change the queries to make new calculations but it creates a problem. The new queries will change the old invoices by recalculating them. And that should not happen. I am sure it is a very common problem and must be a solution for that. I can think of three possible ways: 1,Keep the old application for historical purposes and use the new version for the new jobs. That looks the easiest. 2, Save all the old data in the database and stop recalculating them. There is a problem with this because it would save calculated data in the database. 3, Create complex queries that checks data and recalculate old data with the old method and new data with the new calculations. It looks a bit time consuming task. Does any one have suggestion what way to go? or other possible solution? Thanks in advance -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...esign/200912/1 |
Thread Tools | |
Display Modes | |
|
|