What is the main difference between ACCESS and sql server?

The major difference between the two is in how the software is used.

Microsoft ACCESS is used in home or small business application.

Microsoft Access is not able to handle large quantities of database calls.

Microsoft SQL Server is for medium to large businesses that need a solution for better data processing.