-
Recent Posts
- Lighthouse – Performance statistics for Web Sites
- MS Access Function CreateSimpleStrings()
- Visual Basic Script that can be used to rename a file
- MS Access Function – Run VBS script from within MS Access
- Chrome polishes its menu setup – Chrome Shortcuts now run web pages in application mode
- MS Access Function – import all CSV files from a directory with the same structure into a single table
- MS Access Function – Scan through a directory and write list of files to a table
- MS Access – Code Snippets for Navigating using Internet Explorer
- MS Access Front End – Linked to PostGreSQL back end – a simple walk through using Access 2003
- MS Access Function Collection that can be used to Generate Housing Forecast Figures
Archives
- December 2018 (1)
- November 2018 (1)
- September 2018 (2)
- August 2018 (1)
- May 2018 (2)
- April 2018 (1)
- March 2018 (6)
- February 2018 (2)
- January 2018 (1)
- November 2017 (4)
- October 2017 (2)
- September 2017 (3)
- August 2017 (5)
- July 2017 (1)
- June 2017 (5)
- April 2017 (5)
- March 2017 (6)
- February 2017 (1)
- January 2017 (1)
- December 2016 (2)
- November 2016 (1)
- October 2016 (1)
- July 2016 (1)
- June 2016 (1)
- April 2016 (7)
- March 2016 (2)
- February 2016 (3)
- January 2016 (2)
- December 2015 (3)
- August 2015 (1)
- July 2015 (2)
- June 2015 (4)
- May 2015 (4)
- April 2015 (2)
- March 2015 (4)
- February 2015 (2)
- January 2015 (4)
- December 2014 (2)
- November 2014 (4)
- October 2014 (8)
- September 2014 (3)
- August 2014 (7)
- July 2014 (6)
- June 2014 (7)
- May 2014 (12)
- April 2014 (8)
- March 2014 (2)
- February 2014 (1)
- January 2014 (1)
- September 2000 (1)
Monthly Archives: August 2017
Connect MS Access 2003 to MySQL
It is an incredible feature of MS Access that it is so easy to connect to different databases and use as a Management Studio. Having a unified platform across all the different backends is very very useful. Setting up those … Continue reading
VBA : Scripting in MS ACCESS to run multiple Queries consecutively
It can be necessary for many reasons to want to run queries consecutively without supervision. This was particularly necessary for me when I was doing a system transfer project. The production Oracle server was being used on a daily basis … Continue reading
Posted in All, MS Access, VBA Code MS Access
Comments Off on VBA : Scripting in MS ACCESS to run multiple Queries consecutively
VBA Code : Run a Function and Link Functions together ( or Scripting in MS Access)
MS Access can be used as an extremely powerful scripting environment that can tie together manipulation of data using VBA functions and SQL. Before you can really use this power however you need to know three things 1.Where to put … Continue reading
Posted in All, VBA Code MS Access
Comments Off on VBA Code : Run a Function and Link Functions together ( or Scripting in MS Access)
Upload Shape Files into SQL Azure using OGR2OGR – Explanation of SQL Azure Connection String to be placed within OGR2OGR Command Line
Lets say you have a SQL Azure Server with the following parameters SQL Azure Instance : azureinstance1 Database name within Instance : TouristDB1 Your User Name is : tom Password is : Edinburgh The SQLAzure connection string would be MSSQL:Server=tcp:azureinstance1.database.windows.net;Database=TouristDB1; … Continue reading
Posted in All, SQL Azure, SQL Server, SSMS
Comments Off on Upload Shape Files into SQL Azure using OGR2OGR – Explanation of SQL Azure Connection String to be placed within OGR2OGR Command Line
VBA Function to Create Table of Import strings using OGR2OGR targeting a SQL Server
Do you have many shape files you wish to import into a local SQL Server Database so that you can display them in QGIS or serve them on Geoserver? Here’s a short function I wrote that will take a table … Continue reading
Posted in All, MS Access, QGIS General, SQL Azure, SQL Server, VBA Code MS Access
Comments Off on VBA Function to Create Table of Import strings using OGR2OGR targeting a SQL Server