Danny Lesandrini

Last month we explored the process of importing data from Microsoft Excel.  This month, we look at how to get your data OUT of Access and back into Excel.  While this may be as simple as right-clicking the table or query and choosing Export from the menu, it may also be complicated considerably by the […]

Maybe you have noticed that Excel spreadsheets do not always import data very nicely into Access. Sure, Access can import data from various sources with just a few clicks, but Excel files seem to give the most grief. Out of necessity, I created a code module that employs automation to loop through rows of an […]

One thing Access developers love about using SQL Server as the back end is that it is easy to do maintenance.  I can’t tell you how many times I toured around an office, looking for users who had their client open and connected to the data so I could ask them to log out.  Too […]

A number of months ago I published an article about how one might auto-update a user’s computer with the latest version of the client mdb. I use this process with most all of my applications, but it comes with one downside: the user’s mdb file is overwritten each time an update is delivered, wiping out […]

Simplifying Microsoft Access Development "It looks great, but can you change it so that it doesn’t look so much like an Access database?" I cannot tell you how many times I have heard that in the last year, from both readers and clients alike. Let’s face it, we love Access, but its "look" hasn’t changed […]

Every once in a while, I have been asked to provide FTP services in my Access applications. Years ago, I found some really complex code in a VB Tutorial book that used the Inet Control for managing FTP commands. It was finicky at best and required thousands of lines to accomplish the simplest tasks. While […]

There are a number of ways to execute a SQL Data Manipulation Language (DML) statement from Microsoft Access, besides the obvious process of creating an Action Query and double-clicking its icon. Understanding your options with respect to executing SQL will make your code cleaner, give you more flexibility and we’ll even throw in a great […]

The solution described below should probably not be considered a "best practice" but it works.  It came to life as I was pondering the following conundrum: How can I pass a little bit of data from an internal Access application behind a firewall out to a public web site in real time? In this case, the internal application maintained product orders.  As an order […]

I hope the following article and associated code download will prove to be as useful and exciting for readers of DBJ as they have been for me.  Creating web pages to interface with Microsoft Access databases is a natural evolution for Access developers and there is a plethora of great tutorial information out there. Nevertheless, I continue […]

For some years, I have been asked to review a product that I have only just gotten around to looking at.  It was developed by Garry Robinson, who publishes a very useful web resource called  vb123.com  and who recently wrote one of the best books on Access security,  Real World Microsoft Access Database Protection and Security. […]

One of the first things an Access developer learns is how to write SQL Queries.  A simple request for data might look something like this: SELECT FullName, Address, Phone FROM tblEmployee ORDER BY FullName This type of query uses Data Manipulation Language (DML).  While this example does not perform any great manipulation of the data, […]

I love writing VBA code but I am convinced that, many times what I am trying to accomplish can be done in a more efficient, graceful and elegant way using SQL queries.  Over the last few months, I have tried to develop my applications with this in mind.  The following article is a summary of […]