MS ACCESS, java with embedded SQL question
hey,
I am wondering how to copy a template database I have created (templte.mdb)to another directory using SQL. I am writing a program in java and using the javax.sql package. The way the program operates is that at 12 o clock at night a new database is created for that date 2 year ahead. So for example tonight at 12 o'clock a copy of the database (template.mdb) would be placed in the folder c://databases//2006//march//..... The problem is that I dont know the commands to copy the template database exactly. I need to keep the same column names,structure etc in all the databases!
Any help would be greatly appricated
Stephen
I am wondering how to copy a template database I have created (templte.mdb)to another directory using SQL. I am writing a program in java and using the javax.sql package. The way the program operates is that at 12 o clock at night a new database is created for that date 2 year ahead. So for example tonight at 12 o'clock a copy of the database (template.mdb) would be placed in the folder c://databases//2006//march//..... The problem is that I dont know the commands to copy the template database exactly. I need to keep the same column names,structure etc in all the databases!
Any help would be greatly appricated
Stephen