A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

"Rewrite" an application without affecting old calculations



 
 
Thread Tools Display Modes
  #1  
Old December 2nd, 2009, 08:28 PM posted to microsoft.public.access.tablesdbdesign
ffulmer via AccessMonster.com
external usenet poster
 
Posts: 13
Default "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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:10 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.