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  | 
                             
                            
                                    | 
                                         betesh 
                                        Starting Member 
                                         
                                        
                                        34 Posts  | 
                                        
                                        
                                            
                                            
                                             Posted - 2008-06-18 : 06:54:07
                                            
  | 
                                             
                                            
                                            | We removed SQL Server Express from our server and instead installed SQL Server Enterprise Trial.  We were able to connect via Management Studio and MS Access.  However the MS Access forms are not allowing inserts or deletes.  If we go directly to the tables in MS Access we can add or remove rows but not from the forms.  What could have caused this?  Any ideas?Thanks! | 
                                             
                                         
                                     | 
                             
       
                            
                       
                          
                            
                                    | 
                                     betesh 
                                    Starting Member 
                                     
                                    
                                    34 Posts  | 
                                    
                                      
                                        
                                          
                                           
                                            Posted - 2008-06-18 : 07:32:13
                                          
  | 
                                         
                                        
                                          | I forgot to add that at the time of installation I set the instance name to sqlexpress so that the users wouldn't have to change their connection information.  | 
                                         
                                        
                                            | 
                                         
                                       
                                     | 
                                   
                            
                       
                          
                            
                                    | 
                                     betesh 
                                    Starting Member 
                                     
                                    
                                    34 Posts  | 
                                    
                                      
                                        
                                          
                                           
                                            Posted - 2008-06-18 : 08:10:18
                                          
  | 
                                         
                                        
                                          | I don't know if its possible to delete this thread but we realized the problem was on the Access end, not as a result of the SQL Server Installation.  Thanks anyways.  | 
                                         
                                        
                                            | 
                                         
                                       
                                     | 
                                   
                            
                            
                                | 
                                    
                                      
                                     
                                    
                                 | 
                             
                         
                     | 
                 
             
         |