Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 MS Access
 Date stamping a table

Author  Topic 

Trudye
Posting Yak Master

169 Posts

Posted - 2008-05-28 : 07:42:39
Hi Guys, I would like create a backup table and date stamp it inside of Access (i.e. myBkup_20080527). Does anyone know how to accomplish this?

Thanks,

wilby
Starting Member

3 Posts

Posted - 2008-05-28 : 10:26:08
If you simply want to make a backup copy of a table and keep it inside the datbase your working with simply right click the table choose copy then right click elsewhere in the screen and click paste. You will be asked to enter a name for the table. put the backup name in and click ok. I'm not sure if you can automate this process.


Wilby Jackson
Go to Top of Page
   

- Advertisement -