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  | 
                             
                            
                                    | 
                                         dexpante 
                                        Starting Member 
                                         
                                        
                                        1 Post  | 
                                        
                                        
                                            
                                            
                                             Posted - 2003-09-19 : 05:21:45
                                            
  | 
                                             
                                            
                                            | Good day to all of you.Im quite new to MSDE. These are my questions.1. Is MSDE installed immediately by default when I installed MS Access 2002.What I mean is do I need to install MSDE separate from MS Access.2. How many records can MSDE accommodate compared to MS Access. | 
                                             
                                         
                                     | 
                             
       
                            
                       
                          
                            
                                    | 
                                     tkizer 
                                    Almighty SQL Goddess 
                                     
                                    
                                    38200 Posts  | 
                                    
                                      
                                        
                                          
                                           
                                            Posted - 2003-09-19 : 12:21:16
                                          
  | 
                                         
                                        
                                          | I do not believe that MSDE is installed when you install MS Access 2002.  But that can easily be checked by installing MS Access 2002 and then checking if you have MSDE.As far as answer number 2 goes, there isn't even a record max for MS Access.  But you'll find that MSDE can support more users, larger databases, better performance, etc...Tara  | 
                                         
                                        
                                            | 
                                         
                                       
                                     | 
                                   
                            
                            
                                | 
                                    
                                      
                                     
                                    
                                 | 
                             
                         
                     | 
                 
             
         |