Can an application which is build is MS Access run against a SQL server database
without changing the SQL code?

Also would you use Access in a five user environment. I don't know the size
of the database, it is probably under 100k, but I know that about 2000 records
are added per month and there are probably 30,000 records now. ?