Why convert Access to SQL Server?
] The business reasons for a converting an existing Access database to SQL Server (but retaining Access as the front end) are as follows: – Increased Performance (SQL Server is a proper RDBMS not a file based system like Jet). Calls to the database server result in the requested records being sent across the network, not the entire file in the case of the Jet database. SQL Server is designed for multiple users in a network environment, whereas Access Jet Database was never designed for multiple users. – Increased Robustness. There is a virtual cottage industry based around repairing corrupt acccess databases! (DataRevive operates the leading Access database repair service). Try searching for data recovery companies repairing SQL Server databases… there is no market for such a service! (need we say anymore). – Improved Management and Backup due to SQL Server offering a true database server environment it has integrated backup, maintenance and management features that access lacks. Acc
