Microsoft Access/SQL database VBA programming development and support – Melbourne based

For professional Microsoft Access and SQL Server database developers

July, 2023

Get your SQL data types right

Think about your database as the foundation of your application, and don’t be afraid to correct bad design when you revisit your database. Build your Tables as if your clients have direct access to them and apply referential integrity where possible. If the column is required, then don’t allow nulls. Use the correct SQL Server […]