Danny Lesandrini

There are some things you just can’t do with SQL. The requests usually go something like this … Please list ALL phone numbers related to this contact.Show all items related to the current topic.Include all notes in a single field of the query. This is difficult to do in a query … and impossible to […]

Problem:Power users create queries and reports which are overwritten each time a new version of the client app rolls out. Solution:Give users the ability to identify, save off and retrieve back their custom database objects. The principal behind this process is simple, but pay attention to the details described below or you’ll get lost. If […]

There is a clever, poke-fun-at-George-Bush web site named Weekly Radio Address where you can listen to a new parody of the president each Monday morning. It’s irreverent and probably exaggerates GW’s difficulty with the English language, but it’s funny all the same, and a little contagious. I was trying to come up with a title […]

The Problem It was back in December of 2003 when I published my code for   deploying a new client  file automatically. Since then, I have used that code everywhere and I recently ran into a problem. Some users like to rearrange the columns of datasheets to meet their personal needs, and then when the […]

I have been using Red Gate’s SQL Compare since it was in beta, circa 1999 and I last wrote a product review back in April of 2004 when version 3.0 was released. I recently had occasion to download and use version 5 of the product (when I started doing more with SQL Server 2005), and […]

How to display any Access table on the web A number of recent posts to the microsoft.public.access newsgroup suggest that, more and more, users want to know how to display Access data on the web. Many Access users have looked to Data Access Pages (DAPs) for a web solution. While DAPs provide a rich, easily […]

A couple of years ago, one of my clients asked me to change the background color for their four primary forms because one user with poor eyesight needed greater color contrast. While that user loved the new schema, others hated it and before long, I was toggling colors like a madman, trying to find a […]

I frequently see comments and questions on the newsgroups about how to improve performance with Microsoft Access applications. The knee-jerk reaction is to blame the platform, but in most cases, that’s not the problem. There are many things a developer can do to squeeze an incredible amount of power and performance out of an Access […]

Last month’s article, Automatic Table relinking, demonstrated how to implement table linking behind the scenes, with no user interaction required.  However, there are times when we have to trust the users with the awesome responsibility of pointing to the correct database.  Perhaps it is only at the initial setup of the client application, or perhaps your program […]

There are probably as many good table linking scripts out there as there are good Access developers, and mine is by no means the best. However, the repeated requests on the newsgroups for suggestions on how to manage table links compels me to share the bit of code that I have been using for some […]

I recently asked my wife to come with me to a requirements gathering meeting with a client. She knows so little about computers that I regularly have to remind her how to turn up the volume so she can listen to her CDs. Ironically enough, her ignorance of computers is what I would site as […]

A few months ago, I posted an article here at DBJ named How to Pass Access Data Across the Web.  One reader expressed concern over using the Microsoft Internet Explorer library because of security issues. While I do not share his fear, I appreciate that others might, so I began to think about how the […]