Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum Rss Feed

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Rss Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Posted Nov 5, 2002

Danny Lesandrini

By DatabaseJournal.com Staff

Danny J. Lesandrini currently works as the IT Director for Pharmatech Oncology Inc. at http://www.pharmatechoncology.com/. He holds Microsoft Certifications in Access, Visual Basic and SQL Server and has been programming with Microsoft development tools since 1995. Danny maintains a web site with free code samples at http://amazecreations.com/.

Article Series

Access to SQL Server

Something Not Entirely Unlike Access

Queries on Steroids

Current Articles

The Self-Taught Programmer: Microsoft Access 2010 24-Hour Trainer Review
Migrating Microsoft Access Databases to SQL Server 2008
Leverage Fancy Data Types in Microsoft Access 2010
Iron Speed Designer: Web App Development Made Easy
Using Schemas in SQL Server 2008
Use the Cloud to Manage License Key Authentication
Book Review: Access Solutions Tips, Tricks and Secrets
Microsoft Access Code Snippets and Other Useful Bits
Leveraging Data Macro in Microsoft Access 2010
Book Review: Access 2010 Programmer's Reference
Top 10 Productivity Tips for Microsoft Access 2010
Migrating your Access/SQL Server App to the Cloud
A Microsoft Access Developer's Path to Dot Net
Red Gate SQL Source Control: a Simple and Elegant Solution That Works
Getting Up To Speed With Microsoft Access 2010
Top 7 Reasons to Attend Developer Conferences
Book Review: The Excel Analyst's Guide to Access
Microsoft Access File Backup and Maintenance Options
Microsoft Access Small Business Solutions
Red Gate SQL Prompt Versus Microsoft Intellisense
T-SQL Equivalents for Microsoft Access VBA Functions
Top 10 Reasons Why Access Still Rocks for Developers
Book Review: Knight's 24-Hour Trainer for SSIS
Database Table and Field Naming Suggestions
Create In-Memory ADO Recordsets
Bulk-Batch Email From Microsoft Access
Building a Dynamic Where Clause
What's new in Access 2010
Pros n Cons of ADPs
Working With Outlook from Access
From Access to Outlook
Microsoft Access 2007 Certification
Access TreeView-ListView Basics
Access Paired Forms
Multiple Selection Through Bitmasks
Migrating Access Apps to SQL Server
File Management with Scripting Object
Converting Access Queries to SQL Server
Migrating Access Apps to SQL Server
Browser Style Form Navigation
Auto-Resize Access Subforms
Something Not Entirely Unlike Access
Access 2007 ... For Dummies?
Manage Recordsets in ADPs
Product Review: SQL Prompt
Queries On Steroids ... Part IV
Queries on Steroids ... Part III
Product Review: SQL Refactor
Queries On Steroids ... Part II
Queries On Steroids ... Part I
MS Access: Manage User Objects
Access Object Enhancifier
Save and Retrieve Datasheet Layout with the Windows Registry
Red Gate SQL Compare
Show Me The Tables
Implement User Preferences in MS Access
MSAccess: Load Subforms Dynamically
Manual Table Relinking
Automatic Table Relinking
Book Review: Hands-On Microsoft Access by Bob Schneider
Consume Web Service from Access
Export Data To Excel
Import Data from Microsoft Excel
Auto Logout Users for DB Maintenance
Use System Tables to Manage Objects
Product Review: AccessUI
Simple FTP Methods from Microsoft Access
Executing SQL Statements in VBA Code
How to Pass Access Data Across the Web
Convert Access Tables Into ASP Web Pages
Product Review: Access Workbench
Access Data Definition Language (DDL): Creating and Altering Tables On The Fly
Fascinating Query Tricks
Make Access Command Buttons Work Harder
Book Review: Hitchhiker's Guide to SQL Server 2000 Reporting Services
How to Execute SQL Stored Procedures from Microsoft Access
Book Review: In the Trenches with SQL Server & .NET
The Future of Access
Manage SQL Server Connections in ADPs
Product Review: Object Property Manager
Product Review: SQL Compare by Red Gate Software
Book Review: Real World Access DB Protection and Security
Import XML Data Into Microsoft Access
Navigate Access Forms with Faux Hyperlinks
Automatically Deploy a New Access Client
Access Report Tricks
Book Review: Access 2002 VBA Step By Step
Delete Duplicate Records From Access Tables
Concatenate Column Values from Multiple Rows into a Single Column with Access
How to Merge Records from Two Identical Access Databases
Product Review: FMS Total Visual Code Tools 2002
Product Review: Visual Access XP
Export and FTP XML Files from Access XP
Put XML to Use in Access XP
Product Review: FMS Total Access Speller 2002
Product Review: Red-Gate's SQL Compare
Book Review: Professional SQL Server 2000 Database Design
Product Review: FMS Total SQL Analyzer
Product Review: FMS Total Access Analyzer 2000
ODBC DSN-Less Connection Tutorial
Automate Excel Spreadsheets From SQL Queries
Catalog Your SQL Scripts with MS Access
Another VB-ADO Tool to View Data from a SQL Database
How to Recover a Table Deleted from an Access Database
Simulate an MS Access Datasheet in ASP (Part II)
Merge Records from Two Identical Databases
Simulate an MS Access Datasheet in ASP (Part I)
Database Careers and Other Conundrums
Utility to Build VB Class to Match SQL Stored Procedures
Compact an Access Database with VBS Script
Perform An Unattended Install of MSDE
SQL Server and Access Zero Date Difference
Problematic or Programmatic ODBC
Create Your Own Administration Tool for MSDE