News, links, downloads, tips and tricks on Microsoft Access and related

About Me Search
Name:Alex Dybenko

Location:Moscow, Russia

Friday, January 24, 2014

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


Friday, January 10, 2014

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!

Labels: ,

Thursday, January 02, 2014

"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