I have a table named employee details. as it changes everymonth i want to have a copy for each month how can i do it.

For example like Jan2005, Feb 2005 etc.

Try using the copyobject method.

Select the table in the database window, select File --> SaveAs, then rename it (just in case you aren't interested in trying it programmatically).

Bob

If you are doing monthly maintenance, right click on the table, select copy. Then right click in the Tables object, and click Paste. The paste dialog box will as you if you want to paste the structure, or the structure and data. Select Structure and Data, then rename it in the Save dialog box that comes up.


mmcdonal