Hi everyone,
I have a MS Access 2003 application as front end with SQL Server 2005 as backend.
Previously it was Access 2000 front end and SQL Server 2000 Back end. Now it has been converted to Access 2003 front end and SQL Server 2005 backend. The tables in Access are linked to the tables in SQL Server.
There is a certain table, dbo.MyTable that is updated by a stored procedure spMyStoreProcedure. The table has a trigger MyTrigger that makes sure certain fields are non-empty before the record can be updated.
When I connect the Access2000 version to the 2005 backend, the trigger works, by passing an error message back to the Access application if certain fields are not updated.
When I connect the Access2003 version to the 2005 backend, the trigger doesn’t work.
Any help appreciated.
sudakov
I have a MS Access 2003 application as front end with SQL Server 2005 as backend.
Previously it was Access 2000 front end and SQL Server 2000 Back end. Now it has been converted to Access 2003 front end and SQL Server 2005 backend. The tables in Access are linked to the tables in SQL Server.
There is a certain table, dbo.MyTable that is updated by a stored procedure spMyStoreProcedure. The table has a trigger MyTrigger that makes sure certain fields are non-empty before the record can be updated.
When I connect the Access2000 version to the 2005 backend, the trigger works, by passing an error message back to the Access application if certain fields are not updated.
When I connect the Access2003 version to the 2005 backend, the trigger doesn’t work.
Any help appreciated.
sudakov