Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  Other Forums  MS Access  Access-SQL Link table problem

Author  Topic  Mr_V Starting Member 3 Posts Posted - 2005-11-11 : 08:33:59 I am adapting an Access 2003 app to link to some SQL Server 2000 tables. I managed to insert some rows into a table which has insert/update/delete triggers. The triggers seem to work fine and the rows created by the triggers in a second table are as I expected. However, when I view the second table in Access through a simple query, all I get for all the rows are '#Deleted' in every field. Why does Access think all the rows are deleted? Viewing it through SQL Server Enterprise is fine. Puzzled.