Backups

From: Deb Struble (deb_at_glenmac.com)
Date: 06/01/04 

Date: Tue, 1 Jun 2004 15:51:58 -0500

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!

Relevant Pages

  • RE: RefreshLink error - 3078
    ... ACCESS backend, then have the backend connect to the SQL server. ... the front-end. ... linking wizard to link my DSN. ...
    (microsoft.public.access.conversion)
  • Re: textbox read in as a string?
    ... and SQL; ... knowing what the maximum value of Mult ... and it works just fine if the backend is in Access; ... is being read in as NULL it is being processed as an Integer data type ...
    (microsoft.public.access.modulesdaovba)
  • Re: textbox read in as a string?
    ... I have an access database form that is used as a Front End application, ... is connected to a backend database of SQL Server 2005. ... number as the Int data type in SQL Server. ... Backend isn't NULL!!! ...
    (microsoft.public.access.modulesdaovba)
  • Re: Sql Server Question
    ... everything as now in VFP and is not in the backend at all anymore. ... > issuing a Set filter and/or locate command on the remote data. ... how can one access the SQL table to move the ... > then have a cursor that you can manipulate just like a normal VFP cursor. ...
    (microsoft.public.fox.programmer.exchange)
  • Re: why an SQL Database?
    ... Yes, a good index can speed up searches, but a sql ... It is likely to depend on both the amount of mails to be taken into ... an SQL backend can make sense. ... dreaming alone, it will be only a dream; ...
    (Ubuntu)