Danny Lesandrini

The other day I was working on an existing Access database application when I realized that there were simply too many command buttons for the allotted real estate.  The form was already packed with controls and the client required additional functionality.  There was no way I was going to fit it all without some kind […]

"These guys are pros.  Bill and Peter worked Reporting Services to death to learn everything they could to help you successfully deploy and use the product.  I learned new things when I read it. From the Foreword by Bill Baker, General Manager, SQL Server Business Intelligence, Microsoft Corporation About the Authors  Larger image When I […]

The simplicity and popularity of SQL Server means that more and more developers who build applications with Microsoft Access will want to learn how to take advantage of server side processing using SQL Server Stored Procedures.  The following article will demonstrate a simple method for executing procs from Access.  In addition, we’ll cover questions like these: How […]

The Hypnerotomachia Poliphili (pronounced Hip-ner-AH-toe-mak-ee-a Poh-LI-fi-ly) is an ancient text that is the subject of a da Vinci Code style best seller named Rule Of  Four. This obscure text, completed in 1499, is clearly the work of someone versed in multiple disciplines; architecture, music, painting, gardening and relationships.  The nearly unpronounceable title can be translated […]

On July 15th, the Denver Area Access User Group (see DAAUG at http://www.daaug.org/ ) celebrated its 10th anniversary with a special guest speaker from Redmond, Jon Sigler, the Microsoft Access Group Program Manager.  Jon has worked in the database market for 16 years, originally with the Fox Pro group at Microsoft, and for the last seven years […]

Late last year I picked up a new client whose SQL Server data is accessed through an ADP file (Access Data Project).  The Access part of the application was familiar enough and I am very comfortable with SQL Server, but the Data Project piece was new to me.  The most frustrating aspect, oddly enough, was […]

I have a large queue of products to review, but I bumped this Veraccess tool to the head of the list for a couple of reasons.  First, because I love what Object Property Manager does.  This Microsoft Access development Add-In lets you set form and report properties for multiple objects all at once.  It could literally save […]

My first real production experience with SQL Server came when I upsized a popular event management system written in Access 97. Since Access Data Projects (ADPs) had not been released yet, we had to use Enterprise Manager and SQL Query Analyzer to maintain the database schema. With the advent of ADPs, SQL Server objects may […]

Hackers and Peepers and Thieves, Oh My! I was asked to review Garry Robinson’s new book, Real World Microsoft Access Database Protection and Security published by Apress, because I write reviews, not because I’m a security expert. In fact, my natural overabundant optimism made it difficult for me to rise to the level of paranoia […]

Back in November 2003, I was assigned the task of creating an import routine that would refresh data in an Access 2000 database from an array of XML files.  For some reason, I thought it would be easy, as in "one touch import" or something.  As it turns out, it is not that easy. I […]

I started this article because I felt like I’d stumbled on a clever way to simulate web browser type hyperlinks on my Access Windows forms and I wanted to share that with readers of Database Journal. However, as is always the case, I began to question my own practice, looking for ways to make it […]

How do you manage the distribution of new versions of your Microsoft Access applications to network users? I am sure there are third-party tools you can buy, but it seems like such a waste. All you want to do is: figure out if a newer version is available give the user the option to get […]