Alex & Access

January 24, 2014

Showing locations on Google Map

Filed under: Access — access @ 6:32 am

Multi-Location Mapper: example from Peter’s software how to show objects by latitude and longitude coordinates on Google Map from Access table

January 10, 2014

API Tutorial for Office

Filed under: Office — access @ 10:24 am

The API Tutorial for Office is a great way to get started building apps for Office (only Excel yet, but hopefully we will get it for Access too). The app teaches you how to do basic development tasks interactively by letting you run and edit JavaScript code directly in Microsoft Excel. Check it out!

January 2, 2014

"with recompile" SP option

Filed under: SQL Server — access @ 9:42 am

In addition to my recent post Running SP with Access pass-through query. set nocount on did the trick, but only for one day. My next try was to add with recompile option to store procedure declaration, and after 2 weeks I must admit this was a solution!

CREATE PROCEDURE [dbo].[MySP] @FilterExpr varchar(100)
with recompile
as

Blog at WordPress.com.