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.
    
        
            
                
                    
                        
                            
                                | 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  | 
                                         
                                        
                                            | 
                                         
                                       
                                     | 
                                   
                            
                            
                                | 
                                    
                                      
                                     
                                    
                                 | 
                             
                         
                     | 
                 
             
         |