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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
