connection an access db to sql express backend

can someone advise me as to what i have to do to connect an access frontend to an sql server express backend db on another server.

can i somehow link the tables so a user can enter in data in the access db they are familiar with but it will actually go into sql server.

please help

Hi,

you can either click right in the tables area and add a linked table using an ODBC connection or use a ADP project which can directly access the objects of a SQL Server database. But it is important that you enable remote connections on the SQL Server side using the Surface configuration. See the screencast on my side for more information.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de