I have a database that needs to be closed out on a fiscal year basis (FY2004.mdb). What I want to do is create a function that will copy my database (structure only) to a new file called FY2005.mdb
Once that is complete I can fill the new database with the information that is carried over from the previous fiscal year.
Any Ideas??
Once that is complete I can fill the new database with the information that is carried over from the previous fiscal year.
Any Ideas??