Excel refresh timing and the meaning of a financial total
How refresh completion, calculation order, and business cutoffs determine what a workbook total represents.
3 min read
End user computing
Microsoft Access front ends and back ends
Separating Access application objects from shared data without mistaking a storage change for a rewrite.
4 min read
Moving Access tables to SQL Server while keeping the forms
Tracing retained Access behavior through SQL Server data access, conflict detection, and controlled write ownership.
4 min read
When an Excel workbook is a production application
Recognizing the code, dependencies, and operating responsibilities inside a business workbook.
3 min read