31) 6/26/2004 244904244904  244904.html">ACC2000: ODBC Call Failed (#200) Error Running a Union Query on Linked Visual FoxPro Tables
(244904) - When you run a union query with two linked Microsoft Visual FoxPro tables, you may receive the following error message: ODBC call failed [Microsoft] [ODBC Visual F(#200)]

32) 6/26/2004 245181245181  245181.html">ACC2000: Expression Builder Is Not Available in Visual Basic Environment
(245181) - The Microsoft Access Expression Builder is not available in the Visual Basic Environment.

33) 6/26/2004 240962240962  240962.html">ACC2000: Starting Hyperlink from Access Minimizes Access Session
(240962) - When you start the Internet browser by clicking a hyperlink in Microsoft Access, the Microsoft Access window is minimized.

34) 6/26/2004 241471241471  241471.html">ACC2000: "Microsoft Jet Database Engine Could Not Find the Object" Error Message Exporting Visual FoxPro Table
(241471) - When you use the Visual FoxPro ODBC driver, you are unable to export to any folder except the default database folder. When you try to export to any other folder, you receive the following error message: The Microsoft Jet database engine could not...

35) 6/26/2004 232595232595  232595.html">ACC2000: How to Sum a Calculation in a Data Access Page
(232595) - This article shows you how to sum calculations in a Microsoft Access data access page.

36) 6/26/2004 234343234343  234343.html">ACC2000: How to Secure Database Diagrams in a Microsoft Access Project
(234343) - When you create a database diagram in a Microsoft Access project, it is not stored on SQL Server or Microsoft Data Engine (MSDE) as an object (as a table, a view, or a stored procedure would be). Database diagrams are dynamically rendered, based on...

37) 6/26/2004 225989225989  225989.html">ACC2000: Cannot Use Access Client-Server Tools After Installation of Microsoft Data Engine
(225989) - After you install the Microsoft Data Engine (MSDE) on a computer running Microsoft Access 2000, you are unable to use the following menu commands in a Microsoft Access project: Database Security Synchronize Now Create Publication Pull Subscription...

38) 6/26/2004 209643209643  209643.html">ACC2000: How to Determine the Version of Catalog Stored Procedures
(209643) - This article describes how to find the version of catalog stored procedures in Microsoft SQL Server.

39) 6/26/2004 207868207868  207868.html">ACC2000: "Microsoft Access Can't Represent the Join Expression" Error Message in Query Design
(207868) - After you create a query with the Simple Query Wizard in Microsoft Access, you may receive the following error message if you try to open the query in Design view: Microsoft Access can't represent the join expression ([<TableName>].[<FieldName>] =...

40) 6/26/2004 236531236531  236531.html">MOD2000: Cannot Insert HHCtrl.ocx into a Microsoft Access Form
(236531) - If you try to insert the HHCtrl.ocx ActiveX control into a Microsoft Access form, you may receive the following error message: The operation on the OLE object failed. The OLE Server may not be registered. To register the OLE Server, reinstall it.

41) 6/23/2004 149360149360  149360.html">ACC2: Multiuser Wizards Available in Download Center
(149360) - The Wiznet.exe file includes modifications for two of the Microsoft Access 2.0 Wizards. These modifications allow some of the wizards to be used in multiuser environments so that more than one person can be using the wizard at a time. Included with...

42) 6/23/2004 149358149358  149358.html">ACC2: Sample to Undo Changes in Forms Available in Download Center
(149358) - The Undofm.exe file demonstrates a technique for undoing edits made to a main form as well as multiple edits to subform records using temporary tables and some generic Access Basic functions. A subset of the NWIND database with a modified version of...

43) 6/23/2004 149357149357  149357.html">ACC2: Parameter Typing Utility Available in Download Center
(149357) - The Parameter Typing Utility (Params.exe) can help automate the process of explicitly defining the data types of parameters. It loops through the queries in a database and prompts you for the parameter type of any parameters not explicitly defined....

44) 6/23/2004 148581148581  148581.html">ACC95: Using Updatable Queries White Paper Available in Download Center
(148581) - Advanced: Requires expert coding, interoperability, and multiuser skills. The Harness.exe file contains a white paper that describes a feature of the Microsoft Jet database engine known as updatable queries or updatable views. It is one of the most...

45) 6/23/2004 148572148572  148572.html">ACC95: Viewable Wzcnf70.mda Code Available in Download Center
(148572) - In the retail version of Microsoft Access version 7.0, you can't view the Visual Basic for Applications code for wizards. This special version of the wizards contains viewable wizard code for developers to use as a learning tool. The following file is...