Split Database Behavior - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Split Database Behavior

Diane Seidel

12 months ago

Rookie question: I've been developing forms and testing using local Access tables. Several forms have a Cancel button. After moving a table into SQL Server as a test case, the Me.Undo method I've been using as the Cancel Button onclick event handler no longer prevents row/record changes. This is emblematic of the gotcha I was dreading, which is "things" don't work the same with linked tables as with local tables. How do I find out which methods will behave like Access and which methods have different behavior on linked tables? Is there a reference for this anywhere?

Jeffrey Kraft @Reply

12 months ago

I don't think it's Access that is messing up the me.undo but rather SQL Server and the Rollback statement. If your me.undo method is interacting with SQL Server and involves changes to the database, you can use Rollback Transaction. My experience with SQL Server is very limited

ROLLBACK is the SQL command that is used for reverting changes performed by a transaction. When a ROLLBACK command is issued it reverts all the changes since last COMMIT or ROLLBACK . Again my understanding is limited... so I will now crawl back under I came out of. :D

	Adam Schwanz @Reply 12 months ago
Would need to know more about what is going on with the form. Are there sub forms your entering that's changing focus of the form, refreshes or anything in the code elsewhere? If SQL server is just committing record changes faster, and your me.undo never works, then you may need to use unbound forms. Unbound Forms Template

	Adam Schwanz @Reply 12 months ago
To Add to Jeffrey, my experience is that ROLLBACK can only apply to a change that specifically managed in VBA, managed from the Beginning to Committing of the transaction. That may be another option.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View