Latest MS Access KB Articles

Courtesy of kbalertz.com:

How to import a Word table that contains carriage returns (290169) - When you import a Microsoft Word table that contains carriage returns in its cells, the table is not imported correctly because Microsoft Access interprets each carriage return/line feed as a new record delimiter. To avoid this problem, you can...

How to optimize Office Access and Jet database engine network performance with Windows 2000-based and Windows XP-based clients (889588) - Describes how to optimize Office Access and Jet database engine network performance with Windows 2000-based and Windows XP-based clients.

Cannot edit or update a record on an Access form (209571) - You may not be able to edit a record on a form even though the AllowEdits property of the form is set to Yes . When you try to update data on the form, you may receive the following error message: This Recordset is not updateable. If the form is...

MS05-005: Vulnerability in Microsoft Office XP could allow remote code execution (873352) - This update resolves a security vulnerability that could allow malicious code to run when you store or open Microsoft Office documents from a Web site.

HOWTO: Use TOP N Query from Microsoft Access 2.0 in VB (147724) - One of the new types of queries added to Microsoft Access version 2.0 for Windows is called a TOP N query. If you have Microsoft Access version 2.0 or higher, and Microsoft Visual Basic for Windows version 4.0 and higher, you can use this type of...

How to work with the Outlook E-mail Security Update in an Access database (263084) - Describes that you may receive "A program is trying to automatically send e-mail on your behalf" message when you run the SendObject macro action. Or, you may receive a "run-time error '2293'" when calling the SendObject VBA method in Access.

You receive a write conflict error when you add a record in multi-table view in Access 2002 (295225) - Explains that you cannot insert a record in a multi-table query and you receive a write conflict error if the primary key field of the primary table is an identity field or the query restricts the records to exclude some records from the primary table.

How to create a DSN-less connection to SQL Server for linked tables in Access 2003 and in Access 2002 (892490) - Describes methods for how to create a DSN-less connection to SQL Server for linked tables in Microsoft Access.

When you paste an Excel chart that contains an embedded arrowhead to a Word document, the appearance of the arrowhead changes in Office XP and in Office 2003 (889520) - Discusses a work around for an issue that occurs in Office XP and Office 2003 where an Excel chart that contains an embedded arrowhead does not appear exactly in its original form when it is pasted to a Word document.

No records returned in query between an Access 2000 table and a linked Access 97 table (244137) - No records are returned for a query that joins a Microsoft Access 2000 (Jet 4.0) table to a linked Microsoft Access 97 (Jet 3.5) table. This happens even though you are certain that there are matching records. This behavior can occur only when all...

ACC2000: How to Use a Query to Format Data for a Mail Merge (197520) - In a Microsoft Access table, if you've added formatting to the numbers in a Number field, and you send that data to Microsoft Word through a mail merge, the numbers will lose their formatting when they appear in Microsoft Word. In a mail merge,...

ACC2000: "CREATE TABLE Permission Denied" Error Message in Export to SQL (209656) - When you export a table from Microsoft Access to Microsoft SQL Server, you may receive the following error message [Microsoft][ODBC SQL Server Driver][SQL Server] CREATE TABLE permission denied, database , owner [#262] where...

ACC2000: SQL Server Security Administration Dialog Box Does Not Open (223220) - In Access 2000, if you have not installed the Microsoft Data Engine (MSDE), you can still create Microsoft Access projects and connect to Microsoft SQL Server databases on other computers through a network connection; however, the dialog box for...

ACC2000: Insert Data Permission Required to Modify Table Design (198915) - Novice: Requires knowledge of the user interface on single-user computers. This article applies only to a Microsoft Access database (.mdb). When you try to open a table in Design view, you may receive the following warning message: You can't open...

How to optimize Office Access and Jet database engine network performance with Windows 2000-based and Windows XP-based clients (889588) - Describes how to optimize Office Access and Jet database engine network performance with Windows 2000-based and Windows XP-based clients.

Objects are removed when you convert partial replicas from Access 97 to Access 2000 (263171) - You convert a Microsoft Access 97 partial replica to Access 2000. Then you synchronize the Access 97 partial replica with a converted full replica or with Design Master. All the database objects are removed from the converted partial replica...

ACC2000: How to Set AllowZeroLength Property to Yes in All Tables (210278) - This article shows you how to create a user-defined function to set the AllowZeroLength property to Yes for all the Text and Memo fields in every table in a database. By setting the AllowZeroLength property, you can control whether a zero-length...

ACC2000: SQL Server System Administrator Cannot See System Tables (209179) - When a SQL Server System Administrator tries to import or link SQL Server tables to a Microsoft Access database, the administrator can see most of the SQL Server tables, but not the system tables. The System Objects check box in Microsoft Access...

How to work with the Outlook E-mail Security Update in an Access database (263084) - Describes that you may receive "A program is trying to automatically send e-mail on your behalf" message when you run the SendObject macro action. Or, you may receive a "run-time error '2293'" when calling the SendObject VBA method in Access.

OFFXPDEV: Setup Fails Silently When Password Is Changed for Account Running SQL Services (289516) - If you change the account password that SQL services are running under and then install the Workflow Services for SQL Server without changing the passwords that are stored in the computer's services, the Setup program of Microsoft Office XP...

Photo Editor Help topic refers to Office 2000 instead of Office XP (292124) - Explains that the Help topic refers to Office 2000 when you use Help for information about how to install or remove Photo Editor, but you expect it to refer to Office XP. To work around this issue, click Microsoft Office XP in step 4 of the Help...

The Office XP Shortcut Bar shortcut does not start the Office XP Bar (290744) - Explains that when you click the Office Shortcut Bar shortcut, the Office Shortcut Bar does not appear or the Office 2000 Shortcut Bar appears instead. You can add the Office XP Shortcut Bar through the Office XP CD-ROM in maintenance mode.

MS05-005: Vulnerability in Microsoft Office XP could allow remote code execution (873352) - This update resolves a security vulnerability that could allow malicious code to run when you store or open Microsoft Office documents from a Web site.

You receive an "Access denied" error message, and the program unexpectedly quits when you try to open or save a file in an Office program (891636) - Describes an issue where you receive an error message, and the Office program unexpectedly quits when you try to open a file that is located in a redirected folder or when you try to save a file to a redirected folder.

OFFXPDEV: Cannot Deploy Solution That Is Based on a Copy of the Issue Tracking Workflow Template (287069) - When you try to instantiate a template that you created from the Issue Tracking Workflow sample template, you see the following error in a window named DCOM Server modTBAD failure : [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object...

You receive an "Error 1606" error message when you try to install or remove a Microsoft program (886549) - Discusses an issue where you receive an "Error 1606" error message when you try to install or remove a program such as Streets and Trips, MapPoint, Picture It!, Digital Image Pro, or Money.

Step by Step Interactive tutorials and Getting Started tutorials for Office products do not start (301535) - When you try to use Step by Step Interactive tutorials that is included in Microsoft Office XP, or Getting Started in Microsoft Visio 2002 Help, or Getting Started Tutorial in Microsoft Office Visio 2003, you may experience one of the following...

When you paste an Excel chart that contains an embedded arrowhead to a Word document, the appearance of the arrowhead changes in Office XP and in Office 2003 (889520) - Discusses a work around for an issue that occurs in Office XP and Office 2003 where an Excel chart that contains an embedded arrowhead does not appear exactly in its original form when it is pasted to a Word document.