I am migrating an existing project from an Access backend to and MS SQL 2005 backend. For several tables I use an AfterEdit() to update a change log. This works great with Access, but does not work in SQL Server. Same code, same table and field names. Anybody have any thoughts?
Also, any thoughts on how to get past the MS SQL inability to save changes to a multi table view?