What is the difference between file and client server databases?
• The difference is where the data elements are physically stored. In the file server model (MS Access) the physical storage occurs on the end users computer. In the client server model (Oracle SQL Server) the data elements are stored on a server, and the end user exploits the database elements through a user interface. Interface and storage are therefore seperated in the client server model.