Access 2003 with SQL Express 2005

I am a fresher in using SQL with access.

I am using a code in Ms access to link a table that is in Sql express 2005.

I use this linked table name to download records to the local Access table.

The link is then dropped in Access.

Is there any way to write back records into the linked Sql table from Access.

It does not allow me to delete / add / modify records of a linked table.

How can I do this.

Thanks

Sjohn

YOU will need to specify the primary key on the linked server table that exists in SQL Server. This information is automatically created by default.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de
sql