Access 2003 Solution Center

how-to articles - Access 2003

• How to use command-line switches in Microsoft Access
  Lists all the available command-line switches that you can use to start Microsoft Access from the start menu or a shortcut menu. For example, you can open a particular database, run a macro, supply a password, compact or repair the database.
• Defining relationships between tables in a Microsoft Access database
  Provides the information on how to define relationships in an Access 2002 database, in an Access 2003 database, or in an Access 2007 database
• Description of the database normalization basics
  Describe the method to normalize the database and gives several alternatives to normalize forms. You need to master the database priciples to understand them or you can follow the steps listed in the article.
• How to create an SQL pass-through query in Access
  Describes how to create an SQL pass-through queries in Access which are used to send commands directly to an ODBC database server instead of having the Microsoft Jet database engine process the data.
• How to use a query to filter unique data in Access
  Describes how to use a query filter. You use a filter to eliminate duplicate data. The article lists the aggregate functions that you can use in fields that do not contain duplicate data and in fields that do contain duplicate data.
• How to reset an AutoNumber field value in Access
  Provides step-by-step methods to reset an AutoNumber field value in Access. This includes reseting an AutoNumber field in a single table and reseting an AutoNumber field in a table with referenced tables.
• How to deploy multiple Office products in a single installation in Office 2003
  Discusses how to deploy (or to chain) additional .msi packages or .exe files during the installation of Office 2003. Describes how to chain Windows Installer or non-Windows Installer products.
• Information about running multiple versions of Office with Office 2003
  Describes the problems that you may experience if you run multiple versions of Microsoft Office.
• List of some programming resources for Visual Basic programming in Office 2003
  Provides a list of resources that are available to help you learn VB programming in Office 2003. It includes online help, object browser, MS Press books, KB articles, newsgroups, and other Web resources.
• Description of Office features that are intended to enable collaboration and that are not intended to increase security
  Describes features in Office products that enable specific collaboration scenarios and features that are designed to help make your documents and files more secure.
• Where to find information about designing a database in Microsoft Access
  Describes how to find information about designing a database in Access 2002 and in Access 2003.
• How to find the installation path of an Office application
  This article demonstrates how to use the Windows Installer to find the installation path of Microsoft Office applications.
• Understanding the role of workgroup information files in Access security
  Explains the role and the relationship of the workgroup information file in Access security and some basic concepts of Access security. This article also descibes how to administer the workgroup information file.
• How to install updates to an administrative installation of Office 2003
  Describes how to download and install updates to administrative installations of Office 2003.
• How to change the product key for Office XP, for Office 2003, and for the 2007 Office system
  Describes how to change the product key for Office XP, for Office 2003, and for 2007 Office programs and suites.
• How to suppress the Convert/Open Database dialog box when you open an Access 97 database
  When you open a Microsoft Access 97 database by using Access 2003, the dialog box appears. You can suppress the display of the dialog box if you want to. To do this, you must add the registry entry to the Access subkey in the registry. This setting does...
• How to troubleshoot fatal system errors in Access 2003 when Access 2003 is running on the Windows 2000 operating system
  Discusses the causes of fatal system errors that may occur in Access 2003 when it is running on the Windows 2000 operating system. This article discusses general troubleshooting steps that you can use to solve these errors.
• Error message when you use special characters in Access databases
  Lists the special characters to avoid using when you work with the database object names or the field names in all versions of Access. Describes Access naming conventions.
• How to create an HTML Help system by using either the HTMLHelp API or the HTML Help in Access
  Lists kinds of files that HTML Help Workshop can create and gives the steps on how to a simple Help system in HTML Help Workshop and then how to use the Help file in a Microsoft Office Access 2003 form by using the HTMLHelp API
• How to obtain a volume license key for enterprise editions of Office 2010, the 2007 Office system, and Office 2003
  Describes how to obtain a volume license key for enterprise editions of Office 2010, the 2007 Office system, and Office 2003 System products.
• How to change the company name and user name in Office 2003
  Explains how to change the name of the company in Office 2003 after setup by modifying the Windows registry. Explains how to change the user name information.
• Setup or repair quits unexpectedly with no error message when you try to setup or to repair Office 2007 or Office 2003
  Describes a problem where the installation setup or repair quits unexpectedly and you do not receive an error message.
• Administrators can use Office policy templates with the Group Policy settings of Windows
  Describes how to use the Office policy templates with the Group Policy settings of Windows if you are an administrator.
• How to configure the workgroup templates location during Office 2003 installation
  Describes how to configure the workgroup templates location during Office 2003 installation.
• How to display and to use the File dialog box in Microsoft Access
  Discusses how to display the built-in File dialog box and how to determine the files that the user selects by using the new FileDialog method in Microsoft Access.