O'Reilly logo

Alison Balter's Mastering Access 2002 Enterprise Development by Alison Balter

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required