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.