SQL Server 6.5 Dynamic SQL inside Trigger to Access deleted Table 
Author Message
 SQL Server 6.5 Dynamic SQL inside Trigger to Access deleted Table

When you EXEC a command it is effectively another batch.  Don't know another
way around this.

 Neil Pike MVP/MCSE
 Protech Computing Ltd (MS Solution Provider)
 Using Virtual Access 4.02 build 244 (32-bit) on NT 4.0 SP3



Tue, 11 Apr 2000 03:00:00 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. SQL server 6.5 tables in Access, delete problem

2. MS ACCESS 97/SQL server 6.5: deadlock problems when accessing server tables

3. triggers cascading DELETE with ODBC on SQL Server 6.5 and 7

4. triggers cascading DELETE with ODBC on SQL Server 6.5 and 7

5. migrating sql databases sever 6.5 from sql server 6.5 to another sql server 6.5

6. SQL 6.5 challenge: Preventing clients accessing tables in SQL Server

7. SQL 6.5 - Access table to SQL Server

8. MS Access and sql 6.5 SP 2: #deleted messages on attached tables

9. MS Access and sql 6.5 SP 2: #deleted messages on attached tables

10. Error 3167: Record is deleted - Access 95 and SQL Server 6.5 problem

11. Solution for #DELETED rows with Access as SQL Server 6.5

12. MS ACCESS 97 and SQL Server 6.5 - how to use delete


 
Powered by phpBB® Forum Software