D
Deb Struble
I recently migrated one of my backends from Access to SQL. I am wondering
how other companies handle monthend and yearend copies of the data? In the
past, when it was monthend time I would create a copy of the backend and
copy it into a "month" folder. I now have a monthly folder for every month
for the past 3 years! The Accounting Department has requested I do this and
I have not been able to come up with a real good reason as to why I
shouldn't besides the fact that it is a waste of my time and space. I then
make a monthly copy of the frontend and link it to the current monthly
backend data. Rather than running their reports at a certain point in time
they prefer to run them a few days after the monthend...this is the only
reason I can come up with as to why they want these monthend companies. I
was hoping once I moved everything over to SQL that I could convince them
that it would be too administratively time consuming to keep all these
copies. Any suggestions? How do other companies handle it? I know that
changes have been made to the monthend copies from time to time and I am
wondering if this is even kosher with the General Accounting Practices? If
we continue to store all these copies on the SQL Server will it eventually
bog down the system?
Thanks for any advice!
how other companies handle monthend and yearend copies of the data? In the
past, when it was monthend time I would create a copy of the backend and
copy it into a "month" folder. I now have a monthly folder for every month
for the past 3 years! The Accounting Department has requested I do this and
I have not been able to come up with a real good reason as to why I
shouldn't besides the fact that it is a waste of my time and space. I then
make a monthly copy of the frontend and link it to the current monthly
backend data. Rather than running their reports at a certain point in time
they prefer to run them a few days after the monthend...this is the only
reason I can come up with as to why they want these monthend companies. I
was hoping once I moved everything over to SQL that I could convince them
that it would be too administratively time consuming to keep all these
copies. Any suggestions? How do other companies handle it? I know that
changes have been made to the monthend copies from time to time and I am
wondering if this is even kosher with the General Accounting Practices? If
we continue to store all these copies on the SQL Server will it eventually
bog down the system?
Thanks for any advice!