I am building a database with an Access Project (2003 but 2000 format) front-ending a SQL Server database (2005). I have shipped the database to the client and they have it running on a server somewhere in their establishment. I have shipped the front end to them as well. Since they are not running SQL server on their machine, how do they connect the front end to the back end? SQL Server will need to be installed on their machine or their are compilation problems with the VBA (needs a reference). Is there an alternative to this?

Sorry if this sounds like really basic stuff but although I have done an amount of work in Access and SQL Server, this is the first time I have actually shipped a system - and the client does not have a SQL Server expert!

Many thanks.