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
- 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
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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
Thanks again to you all for taking the time.
James
ASKER
THank you all for your help - SidFishes - got it sorted with the cffile approach !
tks again all
james
tks again all
james
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