SidCharming
Technical User
I work with numerous databases where I have to freeze the current database in time and data for retreiving reports. Every aspect of the database needs to stay in tact whether reports are run the day of close or a year from closing. The reason is for FDA reporting.
Is this a feature that has to be built into the database? or is there any other method?
My current method is this:
1. copy the mdb to a restrictive area for no more data entry
2. Build a module that resets the current computer clock to the closing date (fixes the now() function calculations)
Any insight or help would greatly be appreciated!
Sid from Minnesota
Is this a feature that has to be built into the database? or is there any other method?
My current method is this:
1. copy the mdb to a restrictive area for no more data entry
2. Build a module that resets the current computer clock to the closing date (fixes the now() function calculations)
Any insight or help would greatly be appreciated!
Sid from Minnesota