access 2003 front-end with SQL server as the backend (1 Viewer)

Hi,

Is it possible to link the Access 2003 front-end to the SQL server on the backend?

The database has not been split yet....but I'm just exploring my options.

So for the SQL server, I am thinking of using the free one that you can simply download from Microsoft website.

Is the whole thing going to be as easy as it sounds??

Looking forward to any comments/feedback

Sure; I work with Access/SQL Server apps all the time. Here's a pretty thorough primer:

http://www.utteraccess.com/forum/Beginning-Sql-Server-Deve-t1732935.html