Danny Lesandrini

Over the past couple of years I’ve enjoyed using several FMS utilities with Microsoft Access and Visual Basic, and so I was very anxious to see their first product designed for SQL Server. Prior to receiving my reviewer’s copy, I checked out the FMS Total SQL Analyzer Web page, which does a great job of […]

How well do you know your own Microsoft Access database applications? Over time, even simple FMS Inc. has always been at the forefront, arming developers with analyzer tools to simplify application problem solving and documentation. Join me as I explore features of their latest release. Installation and Getting Started It’s worth mentioning that installation was […]

What is DSN-Less ODBC? In a previous article, Problematic or Programmatic ODBC, I described the various ways I have used to distribute a DSN (ODBC Data Source Name) to users of my client/server applications. Towards the end of that article, I mentioned an Access Database Application I created to serve as a tutorial for people […]

Simplify the Presentation Layer My last article described a utility I created to import sql query metadata into an Access database for cataloging and searching. By applying some standards to the naming and formatting of saved SQL queries, you will be able to reduce the amount of new sql created by leveraging that already written […]

Down the code for this article Work Smarter … not Harder Information is the lifeblood of an organization, and it’s no different here at Quizno’s.   Store information, guest trends, mailing lists … all sorts of data are necessary to run a business. Accordingly, our application development department is frequently asked to run “ad hoc” queries against […]

Does the World Need Another ADO to SQL Lesson? Frankly, I didn’t think so, but I was wrong. One of our clients recently requested information about how to connect to their SQL Server database using ADO code in Visual Basic (and/or ASP). Having worked with ADO for a couple of years already and being so […]

So you accidentally deleted a table, huh? Have you ever deleted an Access table … and then suddenly felt that pain in the pit of your stomach? Well, be of good cheer because all may not be lost. There are at least 2 ways to retrieve your deleted table– one very simple, and another that […]

More ASP Datasheet Tricks This article is a follow-up to last week’s installment about reproducing an Access table in datasheet view using ASP. Last week we looked at the ASP and VB code necessary to create a grid of updateable Input boxes. This week we will create a new page based on the same recordset, […]

Several months ago I was asked to create a utility to simplify the process of combining data from identical MS Access databases into one file. Not long after completing that project, someone posted a request to the newsgroup, comp.databases.ms-access, asking for suggestions for doing the same with his data. I replied to his post with […]

Often Requested Solution I often see posts at comp.databases.ms-access where developers are asking for advice on how to publish their Microsoft Access databases to the web. Replies almost always include advice to learn ASP, and a reference to the book, ASP 3.0 Programmer’s Reference from Wrox is usually provided. Fact is, publishing Access tables to […]

Recently I’ve been mentoring some old friends of mine who want to break into the field of programming. Some need help understanding coding itself, while others want to know what technologies to focus on. All of them are curious about how I got started and want to know where they can get experience, and eventually, […]

What is SP2VB? SP2VB (Stored Proc To VB Class) is a Visual Basic utility that will create the class module code necessary to execute SQL Server Stored Procs with an ADO Command object. In addition to preparing the necessary ADO calls, the utility uses the SQLDMO and SQLNS libraries to query your SQL Server for […]