• >>Is there any need (I can't think of any from my end) to keep the Access and SQL Databases on separate servers?

    Best practice is not to put anything on a SQL Server besides SQL Server. In a small environment like yours this may not be possible.

    I would definitely not install Access on the SQL Server. It would probably be OK to place the Access mdb files on the server, so the server is essentially acting as a network file share.