Link to home
Start Free TrialLog in
Avatar of jameskane
jameskane

asked on

Resetting Database

I have a database Office with 7 tables. At the end of each year I need to empty all the tables for the new  year. Ideally I would like, with one click, to
- have a copy of the year ending database created for archive
- replace the year end database with an empty version (same structure, no data)

The point is, it will be an non technical person resetting the database for the next year - so that is why I need one click simplicity

thanks for any strategy on how to do thhis

james
Avatar of gdemaria
gdemaria
Flag of United States of America image

What type of archive do you want?  Do you want to make a full backup of the entire database and put it on CD and then put it on a shelf?  

Which database is it?   SQL Server 2005?  SQL Server 2000, My SQL ?

-> which ever database it is, you should add that zone to your question

Avatar of jameskane
jameskane

ASKER

Hi, its a msaccess 2003.

I would like a copy of the year ending database 'OFFICE.mdb' to be made - called something like Office_2008.mdb - this would stay in the database folder.

Then the current OFFICE.mdb should be deleted

And finally,  a copy  of a ZERO version of the database 'Office_Zero.mdb' should replace the year ending OFFICE.mdbversion.

Thanks, for the note on flagging the database people, will do;

james





 in the database folder (like 2008Office.mdb). The folder contains a zero data version called OfficeZERO.mdb  and I would like a copy of that 'Office.mdb' to be made and to replace the current
SOLUTION
Avatar of gdemaria
gdemaria
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thanks very much everyone for your inputs. Boy, do I feel out of touch using this msaccess thing !! Really need to move on to mysql or something .  I am going to try both approaches proposed and am  sure one of them will work.  Just a little clarification Jones911, you are proposing I do this query for each of the 9 tables and then insert each into the archive database - or is there a way to do this for all tables in one shot ?

Thanks again to you all for taking the time.

James
THank you all for your help - SidFishes - got it sorted with the cffile approach !

tks again all

james