I've been asked to look into making some changes to reduce redundant work performed by some of our applications. Part of my task is to produce a report that will help quantify the potential benefits.

Don’t have access to Access? You can use Excel to open the database you want, using the MS Query Wizard. Here’s how to multitask using Office’s versatile spreadsheet program. There’s data in your ...

Run-time Error '2342' states:<BR>"A RunSQL action requires an argument consisting of an SQL statement."<BR><BR>I am having some issues with an inline query to sum up ...

What are the advantages of using Access as the front end to a SQL Server database? For starters, it’s likely that your client’s users will be more familiar with it, and it’s relatively easy to put in ...