I have created an application is Access 2000 that when the user open the database it determine the current fiscal year and everything else in the database in based on that fiscal year.
The user can change fiscal years at anytime and all the information viewed is then based on that fiscal year
This is done by a function name FY(). This Function exist in all the majority of queries and forms. We are switching the data source to SQL Server 7.0 and would like to keep the same Access front-end. When we changed the data source we noticed an unacceptable performance hit. This was due to the fact that SQL runs this function for every individual record. Does anyone have any suggestion on how to overcome this problem?
