I specialize in developing/converting Access applications linked to data in SQL Server. Expert in VBA programming and writing TSQL, and have been awarded Microsoft Most Valuable Professional status for the last 7 year (my MVP profile can be viewed on the Microsoft MVP Site), written and acted as a technical author for Microsoft Press on several books.
Read More »
Most of the systems I work on use an Access front-end application, I also construct .net web interfaces and use SSRS for some clients. I use a product called the Migration Upsizing SQL Tool,...
Access data conversion to SQL Server
As the volume of data and number of users in an Access database increases, then to get better reliability and performance it is a great idea to move the data into SQL Server. The existing Access desktop database, can then be re-linked to the data in SQL Server. Having converted over 50 systems in the last 10 years, I can offer a great deal of expertise in over-coming difficulties when migrating data, planning security and using schemas to improve the manageability of the design.
The services that I offer are based around Microsoft Access and SQL Server. Some of these services are based around using a product called the Migration Upsizing SQL Tool (MUST), which has been successfully sold internationally to over 200 companies, www.upsizing.co.uk
Access SQL Server performance tuning
A key selling feature of MUST (www.upsizing.co.uk) is the products ability to convert queries in Access to SQL Server views and stored procedures. I can offer a service where I will perform the conversion, also handle VBA global variables and VBA functions, converting these to SQL Server functions. As part of migrating an Access database to SQL Server, converting the queries and batch processing can be very important in obtaining satisfactory performance.
Access report conversion to browser based SQL Server Reporting Services
Converting Access reports to rdl reports which utilize SQL Server Reporting Services (SSRS), allows the reports to be viewed in a...
Read More »