Microsoft Access Support
- Ongoing Support & Upgrades for your Database
- Enhance your Database with New Features
- Upsize your Database to the Web
Microsoft has been updating their SQL Server Management Assistants on a regular basis, and they just updated the SSMA
I recently worked on a project where our client is selling a product throughout the USA built on Access
On occasions when building a project involving an Access front-end and a SQL Server backend, we ‘ve run into this question. Should we use a trigger for something? Designing a SQL Server trigger for Access application may be a solution but only after careful considerations. Sometime this gets suggested as a way to keep the business logic within database, rather than the application. Normally, I like having the business logic defined as close to the database as possible. So, is trigger the solution we want for our Access front-end?
I’ ve found that