Showing locations on Google Map

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

API Tutorial for Office

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!

"with recompile" SP option

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
…