Category Archives: Access to SQL Server Migration

Migrating your Access Backend to a SQL Server Database

List SQL Server Foreign Keys

SQL Server provides system views to display meta data like Tables, Columns and Constraints. The following View or Stored Procedure brings together some of these system views to show your FK contraints. Note the terminology – The referenced table and column as the “parent” in the relationship while the “child” is termed the Parent as… Read More »

Access Bugs

Historically, Microsoft have introduced a significant bug in an Office release about once a year. Lately it has been more often. I think that we can all accept that bugs will happen. The main issue here is communication. Microsoft have never been good at communication. Never will be. It’s not in their nature.To start, they… Read More »

Excel vs Access

The Advantages of a Relational Database Application over Spreadsheets Why should I use Access instead of Excel to run my business? One of your major goals in management is to create systems that allow you to step away from micro managing while knowing that your business is run the way you want it to be… Read More »

Managing Application Updates

Test and Release Each client has a person responsible for testing and then releasing new versions – The Client’s Project (or Application) Manager. This is important as it ensures that – a) The Client has the opportunity to test in their environment for critical use cases before THEY release b) They share responsibility for any… Read More »

Containers, Collections and Objects

An Access Database is a container. Within this container are collections of objects which include tables, queries, forms and reports. Objects can themselves be containers. For example a table contains columns (or fields) while forms and reports contain controls that display data. So we could iterate through our database’s Tables (TableDefs) and through each Table’s Fields like this… Read More »