11/19
Garry Robinson discusses some of the subtleties that you can apply to your database tables prior to upsizing your tables to SQL Server. In this article, I will show you how to fix up some of your Access backend before you make the conversion. 10/17
Thanks to internet search engines, users are used to searching for text but unfortunately even the desktop search tools can't look into tables (easily). This article outlines a simple tool to search Access tables or linked tables to find if a text string(s) exists in those tables.
9/15
Learn how to set up an off-site copy of a working MySQL database, an Access version of the same back-end, and a front-end that could link to either.
8/11
Garry Robinson fills the gap found in the Access 2007 help manual by providing some much needed help on how to use the charting object in Access 2007.
7/18
Garry Robinson outlines how usage data can make the quest to speed up an Access database more focused. The article also delves into an Access 2007 ACCDB only feature called TempVars.
6/16
Learn how to improve on what already is a very significant
security improvement in Access 2007--database encryption.
5/16
Part one of this article demonstrated how to retrieve data and save it into XML using Microsoft Access and MSXML. Part 2 shows how to add new data to a Web2 website ("in the clouds").
4/14
Learn how you can use an Access Database and VBA to manipulate a Web 2 application.
3/21
This article focuses on getting started with Access TreeView and ListView controls.
3/04
ShrinkerStretcher is an add-on module for Access that will dynamically (or statically) rescale Microsoft Access forms, fonts, and controls to fit any screen resolution, desktop scheme, font setting, or form window size.
2/13
Nearly every Access developer will admit to having learned much about user interface design from the Northwind sample database but in time most of us look for ways to improve upon, or deviate from, the template we know so well. My latest idea makes its début in this month's article: Paired Forms.
1/18
Ever wish you could store multiple selections to a single table column?
The solution, Bitmask Fields, have been in use for decades. Follow along
as Danny Lesandrini shows you how to unlock the power of two.
12/17
The final article in this series covers Optimizing Client Server Queries.
12/12
A hole in Microsoft's Access database permits hackers to install software on vulnerable systems, the US-CERT team warns.
11/16
Once you get familiar with the File Scripting Object (FSO), managing files in Access is not so bad--getting started is the painful part. To help you along, this month's download includes sample code for both Access (early bound) and VB Script (late bound).
