Using Transaction Processing in a Client/Server Environment

When dealing with transactions in a client/server environment, you must consider several additional issues: when and how transactions occur, what types of transactions the server supports, and what types of problems can occur. When using Access in a client/server environment, it is always best to implement transaction processing on the server rather than in your ADO code. Chapter 8, “Designing SQL Server Stored Procedures, User-Defined Functions, and Triggers,” covers transaction processing on the server. This means that if all of your update code is in a stored procedure, and the stored procedure contains transaction processing, you can roll back the transaction at the server level ...

Get Alison Balter's Mastering Access 2002 Enterprise Development now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.