Click here to show the site navigation frame
You'll find below the back issues of Smart Access Extra, the biweekly Access newsletter that I used to write for Pinnacle Publishing. Pinnacle has cancelled SAX, but I'm pigheaded enough to want to continue pontificating on my own. If you've missed Smart Access Extra, hop over to the subscription page for Access Developer News, its new incarnation. And please tell anyone else that you think might be interested!
Also available: the collected SQL Corner columns (includes columns through Vol. 2 #20).
Current Survey: Access features
1) Missing the Boat Twice
2) A Blast From the Past
3) Survey Results
4) Speed Ferret 4.1 Ships
5) SQL Corner: Miscellaneous DDL
6) On the Web
7) SQL Server Security Rollup
8) KB Article: Unreplicate a Database
9) Tip: Keyboard Shortcuts
10) Reader Mail
1) Last Chance on Licensing
2) Digging into Office XP Web Services
3) Survey Results
4) Developer's Bookshelf: Understanding Web Services
5) dbPAL Gives You a New Way to Work with Databases
6) On the Web
7) CodeCharge Studio Moves Data to the Web
8) KB Article: SP4 and SP5 May Harm Queries
9) Tip: Defragment and Compact
1) .NET Add-Ins for Office
2) Inventory Office Patch Levels
3) Survey Results
4) FreeAccess Offers Free Access Stuff
5) SQL Corner: CREATE TABLE With Jet 4.0
6) On the Web
7) FMS Ships TA Detective 2002
8) KB Article: Can't Pack That Database?
9) Tip: Sorting Records in a Report
10) Reader Mail
1) Another Month, Another Update
2) Web Services in Access: A Worked Example
3) Survey Results
4) Developer's Bookshelf: WRITING SECURE CODE
5) Leverage Access Reports into IIS
6) On the Web
7) LiteSpeed Backups for SQL Server
8) KB Article: Bind DAPs to XML
9) Tip: When is a Change not a Change?
10) Reader Mail
1) Office NGO?
2) OLAP From Access
3) Survey Results
4) FMS Ships TA Analyzer 2002
5) SQL Corner: CREATE TABLE
6) On the Web
7) Two Useful Mailing Lists
8) KB Article: Access 2K vs SQL 2K
9) Tip: Sorting Randomly
10) Reader Mail
1) Avoiding Jet Corruption
2) Service Packs All Around
3) Survey Results
4) Developer's Bookshelf: Code Complete
5) More from FMS
6) On the Web
7) Review: Softlocx 6.0
8) KB Article: /convert is busticated
9) Tip: Find a Record with a Combo Box
1) Patch MOD -- or Improve It
2) SQL Server Security Fun & Games
3) Survey Results
4) Office XP + .NET = Fabrikam 2.0
5) Review: Total Visual Code Tools 2002
6) SQL Corner: Outer Joins
7) On the Web
8) One More Security Issue
9) KB Article: Troubleshooting Replication
10) Tip: Find a Corrupted Object
11) Reader Mail
12) Tooting my Own Horn
1) .NET Ships
2) Using Web Services From Office
3) Survey Results
4) Jet is Dead
5) Developer's Bookshelf: Microsoft Access Projects
6) Review: Total Access Speller
7) On the Web
8) KB Article: Display Images
9) Tip: The TextStream Object
10) Reader Mail
1) Office XP SP1 Released
2) More Downloads: MDAC 2.7, SQL Server 2000 SP2
3) Survey Results
4) Using ADO .NET with Access Data
5) MZ-Tools Beefs Up VBA
6) SQL Corner: Make Table Queries
7) On the Web
8) CityDesk: Web Site Publishing with an Access Base
9) KB Article: Incorrect Chart Values
10) Tips: Google and Queries
11) Reader Mail
12) A Date Bug
13) Beta Test Larkware Locksmith
1) MDAC 2.7 Ships
2) Survey Results and a New Survey
3) New Toddlers in the Office Family
4) Shameless Plug
5) Developer's Bookshelf: CODE COMPLETE
6) Coding a Survey
7) On the Web
8) KB Articles: Setup and More Setup
9) Tip: More ADO Techniques
10) Reader Mail
1) Microsoft vs. Full Disclosure
2) Evangelizing .NET to Office Developers
3) Smart Access Extra Survey
4) Online SQL Course
5) Dealing with Freeform Text Files
6) SQL Corner: UPDATE Queries
7) Web Site: Risks Digest
8) A Fistful of Downloads
9) KB Article: Deploying DAPs
10) Tip: Use the Performance Analyzer
11) Reader Mail
1) New Schedule for Smart Access eXTRA
2) ADO Crash Course
3) Packaging Wizard Patch Released
4) Developer's Bookshelf: Software Project Survival Guide
5) Access Conversion Resources
6) Web Site: Shell Extension City
7) ADOTest Helps Troubleshoot ADO Problems
8) KB: Can't Upsize Large Tables
9) Tip: Choose Your Cursor
10) Upsizing Queries
1) Smart Access eXTRA Bonus Issue!
2) Choosing an Access File Format
3) Check Your Network Security with a New Tool
4) Office Resource Kits Online
5) Another Microsoft Deal
6) SQL Corner: INSERT Queries
7) Web Site: SQL-Server-Performance.com
8) Check Your CPU Speed
9) KB Article: Sudden Loud Noise!
10) Tip: Percent of Whole in a Totals Query
11) Reader Question: Magic Vanishing Margins
Note: This special ad-free summer bonus issue is only available here.
1) New Developer Certification Coming
2) Writing on the Wall for NT 4.0
3) Open EXE Attachments
4) Developer's Bookshelf: Extreme Programming Explained
5) Access XP - Yes or No?
6) This Issue's Web Site: Ultima Thule
7) Two More Microsoft Downloads
8) KB Article: Query Secure Database via Jet and ASP
9) Tip: Registering DLLs
10) Reader Mail
1) Security Woes on Client and Server
2) Access Database of Security Vulnerabilities
3) Microsoft Licensing Changes to Bite Some Users
4) Office Web Component Toolpack
5) SQL Corner: DELETE Queries Part 2
6) Web Site: FutureWave
7) Help for API Users
8) KB Article: Importing Text Into Access
9) Tip: User Login IDs
10) Reader Question: Link to Database on Web?
1) Microsoft Announces Data Analyzer
2) Two New Access 2002 White Papers
3) The Access Job Market
4) Devel. Bookshelf: User Interface Design for
Programmers
5) Access 97 on Windows XP
6) Web Site: Westside
7) Registry Explorer (Almost) Replaces RegEdit
8) KB Article: Cannot Change Ownership Of Query
9) Tip: Viewable Access 97 Wizard Code
10) Reader Question: Using RunPermissions
1) Completely Unscientific Survey Results
2) SQL Server 2000 Service Pack 1 Is Here
3) Reader Mail
4) Microsoft News Shorts
5) SQL Corner: DELETE Queries
6) This Issue's Web Site: The Case for the Surrogate Key
7) Updates for Office XP? Already???
8) KB Article: Using Microsoft Jet with IIS
9) Tip: Using BuildCriteria
10) Reader Question: Two-for-One Sale
1) Reader Mail
2) Make Your Computer Grovel
3) Smart Tags In and Out of the News
4) A Developer's Bookshelf: Peopleware
5) Another Month, Another Service Pack
6) This Issue's Web Site: Colby Consulting
7) ActivePorts Looks Under the Hood
8) KB Article: Quit Windows With a Macro
9) Tip: Fake a Button With a Label
10) Reader Question: Linking With Passwords
1) Smart Access eXTRA Archive
2) Microsoft Formalizes Windows Product Lifecycle
3) Finding the MAC Address
4) Sorting Out SharePoint
5) Your Office Mileage May Vary
6) SQL Corner: Subqueries
7) This Issue's Web Site: Candace Tripp's Links Site
8) Find That Font!
9) KB Article: Calculate Daily Hours
10) Tip: Create an ADO Connection String the Easy Way
11) Reader Feedback: Another Help File Tool
1) How NOT to Make a Table Read-Only
2) MS Press Experiments with Custom Publishing
3) More Promotion of Office XP
4) Developer's Bookshelf: Death March
5) Globalization Help from Microsoft
6) SQL Comments: More about UNION Queries
7) Web Site: The Helpware Group
8) SQL Server XML Support Enhanced
9) KB Article: Long Passwords
10) Tip: ALL vs. ANY in Subqueries
11) Reader Question: MAC Address Retrieval
1) Beating the Drum for Office XP
2) Office XP Technical Information
3) Tiptoeing Through the KBase
4) RSS: A Cautionary Tale
5) SQL Corner: UNION Queries
6) This Issue's Web Site: Database Advisors Inc.
7) A Couple of Jet Downloads
8) Jet OLE DB 4.0 Provider vs. Old Workgroup Files
9) Tip: Linking Without Linking
10) Hiding Tables
1) Access 2002 Features for Developers
2) SPEED Ferret 4.0 Released
3) Office Developer Center Covers Access 2002
4) A Developer's Bookshelf: After the Gold Rush
5) Deploying ADP Solutions to Remain Difficult
6) Web Site: msOfficePRO
7) FMS Releases Beta of SQL Server Analysis Tool
8) KB Article: New Jet 4.0 Features
9) Tip: Exporting to Excel Again
10) How to Check Spelling From Code
1) Office XP Pricing Sort of Announced
2) Microsoft Security Takes a Beating
3) Using Dynamic Byte Arrays with Unicode
4) Microsoft Merges with Great Britain
5) SQL Corner: GROUP BY with HAVING and WHERE
6) Web Site: Tony's Main Microsoft Access Page
7) .NET Enterprise Servers Evaluation Editions
8) KB Article: Programmatically Create Code
9) Tip: Use CopyFromRecordset to Move Data to Excel
10) Reader Question: Access vs. dBase
1) Latest Patch for MOD
2) Egg on VeriSign's Face
3) Followups: File Corruption, RI, SQL Dates
4) A Developer's Bookshelf: XML in a Nutshell
5) Microsoft Unleashes a Hailstorm
6) This Issue's Web Site: Hungry Dog Software
7) Microsoft Office XP Product Guide
8) KB Article: Get Rid of the Office 97 Assistant
9) Tip: Make Your Debugging Sessions Easier
10) Reader Question: Linked Object Path
1) Smart Access eXTRA Download
2) OXP RTM
3) Access on Slashdot
4) Revisiting Referential Integrity
5) SQL Corner: Yes, It's Dates Again
6) This Issue's Web Site: SQLSecurity.com
7) Download: FTP Voyager
8) KB Article: Who's Got the Wizard?
9) Tip: Use PrintKey for Screen Captures
1) Office XP Bubbles Along
2) Database Security Resources on TechNet
3) An Office Web Components Resource
4) A Developer's Bookshelf: Writing Solid Code
5) You Too Can Be An Executive!
6) Is Your Software Breeding Bolsheviks?
7) SQL Corner: GROUP BY
8) This Issue's Web Site: CDOLive
9) Worth Downloading: Watch Your Back
10) KB Article: Export Text as Unicode
11) Tip: Referential Integrity is Not Always What it Seems
12) Reader Question: Numerals to Words
1) Are You Sick of Being Experienced?
2) Check on MSDE Throttling
3) FMS Releases Zip Code Database
4) A Developer's Bookshelf: The Pragmatic Programmer
5) Readers Beat up Editor: Film at 11
6) SQL Corner: ORDER BY
7) This Issue's Web Site: Desktop Engineer's Junk Drawer
8) Hungry Dog Does OLAP
9) KB Article: Where's That Toolbox?
10) Tip: Bound Forms in ADP Files
11) Reader Question: Mystery Corruption
1) Forget Everything You Know About VBA
2) The Mouse Wheel Again
3) DDoS: Worse than the Dentist
4) A Developer's Bookshelf: The Mythical Man-Month
5) ADO.NET: Forward into the Past
6) SQL Corner: Wildcards in the WHERE Clause
7) This Issue's Web Site: IBuySpy.com
8) Some Updated Downloads
9) KB Article: Which Wizard is Where?
10) Tip: Another Way to Prevent Database Bloat
11) Reader Question: First and Third Fridays
1) Use Access 2000 With SQL Server 2000
2) Keep Those Cards and Letters Coming
3) Don't Tear Your Hair Out Over Replication
4) Discontinued Microsoft Products
5) SQL Corner: The WHERE Clause
6) This Issue's Web Site: DEVELOPERSHANDBOOK.COM
7) Altdesk Expands Your Work Surface
8) KB Article: Get Rid of the Convert/Open Dialog Box
9) Tip: Shrink Report Section Heights
10) Reader Question: Disable the Mouse Wheel?
1) What I Want for 2001
2) Jetcomp Might Save Your Bacon
3) Five Quick Tips for Dressing Up Access 97 Apps
4) Don't Upsize to SQL Server 2000
5) SQL Corner: Cross-Products and Inner Joins
6) This Issue's Web Site: Access VBA Central
7) Microsoft Internet Services Network
8) KB Article: Troubleshooting Invalid Page Faults
9) More Reader Experiences
10) Office for the Classroom?
11) Tip: When Does a Null Equal a Null?
12) Reader Question: Automating a PowerPoint Slideshow
1) Readers Respond
2) Office 10 Drops Features: Should You Care?
3) Deploying Data Access Pages
4) Bill Gates is Dead?
5) SQL Corner: The SELECT Clause
6) This Issue's Web Site: Sysinternals
7) Pinnacle Joins Forces With ComponentSource
8) KB Article: Changing Custom Command Bars
9) Tip: Use SysCmd for Your Own Progress Meter
10) Reader Question: Sorting in Reports and Queries
1) Office 2000 SP2 Released
2) Jet 4.0 Service Packs
3) Access to IBM Revisited
4) This Issue's Web Site: Microbus
5) XML Spy 3.5 Enters Beta
6) KB Article: Sinking Form and Report Events
7) Tip: Tweaking AutoNumbers
8) Reader Question: Object Efficiency
1) Save Money on Office with Microsoft Open License
2) Office 10 At Comdex
3) Rent-an-Office
4) Netscape Navigator with Office
5) This Issue's Web Site: The Access Web Revives
6) Component Checker Updated
7) KB Article: Deploying ADP and MSDE with MOD
8) Tip: Optimizing Modules
9) Reader Question: Access to IBM?
1) The Places Add-in for Office 2000
2) Office 10 Beta 2 Ships
3) bCentral Offers New Services
4) The Other Microsoft
5) This Issue's Web Site: PK Solutions
6) ADO Query Tool
7) KB Article: New VBA Functions as Expressions
8) Tip: Finding Code
9) Reader Question: Missing Access Exam
1) Access and... PowerPoint?
2) No More Access Certification
3) .NET Partner Readiness Kit
4) This Issue's Web Site: Trigeminal Software, Inc.
5) Sample Query Database Available
6) KB Article: Name AutoCorrect May Not Work
7) Tip: Compact and Decompile for Access 2000
8) Reader Question: Builder Button Shortcut?
9) Kaplan on Decompiling
1) MDAC 2.6 Ships
2) SQL Sever 2000 Breaks ADPs
3) Access Run-Time Minimum Released
4) SageKey Offers Runtime Alternative
5) This Issue's Web Site: NTBugTraq
6) Feedback: More on /Decompile
7) KB Article: Incorrect Syntax Near '\'
8) Tip: Formatting Variable Declarations
9) Reader Question: Adhoc Query Builder?
1) Microsoft Opens Office Developer Center Online
2) A Nasty Jet 4 SP4 Bug
3) A Web Site to Watch
4) In the October Issue of Smart Access...
5) More on /Decompile
6) This Issue's Web Site: Unmaintainable Code
7) WebCheck Offers Convenient Searching
8) KB Article: Report Snapshots on Web Pages
9) Tip: Drag and Drop Design
10) Reader Question: Missing VBA Runtime References
* Microsoft Officially Leaks Office 10
* Word, Web Bugs, and People Who Should Know Better
* A Client-Server "Gotcha"
* Accessory
* XML Spy Makes XML Editing Easy
* Office 2000 Update History
* Keep Up-to-date on Support News
* Use Assertions to Check Your Code
* Commas in Value Lists
* Access Workflow Designer walkthrough
* Application Center 2000 Beta
* The Pragmatic Programmer
* WinInfo
* Microsoft Product Trials
* Objects in the ADO Tables Collection
* Optimizing Case Statements
* /Decompile in Access
* Office 10 is on the way
* SQL Server 2000 RTM
* MDAC 2.5 SP1
* New Suites from FMS
* The Toolshed
* Monitor Your Servers
* Not enough free memory on a form
* Change Your Default Folder
* Terminal Server with Access?
* Mail call
* Access Security Hole
* Demystifying Access Projects
* ADO+ Is Coming
* Report Design Tips
* FMS, Inc.
* Headline Viewer
* Understanding Event Order in Access 2000
* Use Queries to Export Tables
* Grouping by a SQL Server bit column
* Reader Feedback
* MDAC Component Checker
* MSDN Online Bug Center
* Google Search Buttons
* The Access Web
* Access Data Retrieval Add-In
* Rank Records Within a Query
* Make Your Taskbar More Useful
* Mysterious Failing VBA Functions
* Understanding Name AutoCorrect
* Action Queries in Access Projects
* Save Your Office Settings
* Thinking about Office.NET
* Woody's Office Portal
* Keyboard Shortcuts
* Random Classical Music
* First() and Last() are Probably Not What You Want
* Database Path in Access 97
* Those Data Access Methods
* What's In That MDAC Stack?
* Office 2001 for the Mac: A Hint of Things to Come?
* In the June Issue of Smart Access...
* Code Librarian Updates
* This Issue's Web Site: Joel on Software
* Vault: An Alternative for Unstructured Information
* KB Article: Confusing Input Masks
* Tip: Numbering Lines on Reports
* Reader Question: Those Pesky #Name? Errors
* Record-level Locking in Access 2000
* Access 2000 and Access 97 Together
* Using Query Parameters From Code
* Axent
* Find Those Startup Programs with Autoruns
* Form Shortcuts for your Database
* Drag and Drop Data Import
* Quick Continuous DAPs
> MDAC 2.5 released
> Total Access Analyzer 2000
> SQL Server 7.0 Service Pack 2
> Is Access Dead?
> Uncle Jim's Microsoft Access Tips
> Jafsoft Limited AscToHTM
> Using dBASE files with Access 2000
> Depersonalizing the Access menus