Access 2003 Solution Center

Database Design

How to use data transformation services (DTS) to export data from a Microsoft Access database to an SQL Server database
Describes the method of using DTS to import or export data between SQL Server and any OLE DB or ODBC data source. Includes the steps to copy the order tables from the Northwind database to a new database by using the DTS Import and Export Wizard.
Part 2 of Keeping your information accurate in Access 2003 and Access 2002: Using the data type to restrict data
Provides steps that describe how to use data types for each field to restrict data in Access 2002 and Access 2003. This article is part 2 of a series of eight articles that explain how to keep your information in Access accurate.
Location of the Northwind sample files in Access 2003
Describes that you can open the Northwind sample files from the Help menu in Access 2003. You can also open the files from the "Office Path\OFFICE11\SAMPLES" folder.

Description of the Access 2003 post-Service Pack 1 hotfix package: April 28, 2005
Describes the issue that is fixed by the Access 2003 post-Service Pack 1 hotfix package that is dated April 28, 2005.
BUG: You receive an error message when you open or convert an Access 2.0 database file in Access 2003
Describes the "You must install the Microsoft Access 2.0 Converter in order to convert this file" error message that you receive when you open or when youconvert an Access 2.0 database file in Access 2003. The converter is available for download.

Documenter does not display the DELETE query in Microsoft Access
Describes a problem that occurs when you run a Documenter report in Access. The DELETE query does not appear in the Documenter dialog box selection.
Field size is changed when you copy and paste a table in an Access project
Describes a problem that occurs when you copy and then paste a table that has fields greater than 256 characters in an Access project. The fields are truncated when you view the the fields in the resulting table. Workarounds are provided.
Error message when you run a query in Access: "The field is too small to accept the amount of data you attempted to add"
Describes a problem in Microsoft Office Access where you receive an error message when you run a query. Or, you do not receive an error message but a Memo field is truncated to 255 characters.