Microsoft Knowledge Base Article Links
From the Database Community Forum
Archive
July 2004
Week Ending July 3, 2004
Microsoft Access
- ACC2000: Linked Excel Worksheet Grows by 50 to 100 Percent When Updated in Access
- ACC2000: Visual Basic Editor Displays Hidden Modules
- ACC2000: Unsupported SQL Keywords Are Not Listed in Microsoft Access
- ACC2000: How to Attach Existing SQL Server 7.0 Database Files to Microsoft Data Engine (MSDE)
- ACC2000: New Microsoft Excel Data Does Not Appear in Microsoft Access Form
- ACC2000: Standard Toolbar Not Available in Microsoft Access
- ACC2000: How to Start Another Application from a Data Access Page
- ACC2000: Shortcut Keys May Not Work in Access Project
- ACC2000: Cannot Use Legacy Database Templates with Access 2000
- ACC2000: PreviousSection Property Causes Microsoft Access and Internet Explorer to Quit Unexpectedly
- ACC2000: Microsoft Script Editor Does Not Execute the OnBeforeUnload Window Event Procedure
- ACC2000: Tips for Improving Subform Performance
- ACC2000: How to Control the Number of Records Printed per Page
- ACC2000: How to Create a 'Continued' Header with Groups That Span Multiple Pages
- ACC2000: Starting Another Application from a Text Box on a Form
- ACC2000: Troubleshooting Tips for Error Values
- ACC2000: How to Print a Variable-Length Character String
- ACC2000: Finding Help Topics in Microsoft Access 2000
- ACC2000: Delete Queries Cause Size of Replicated Database to Grow
- ACC2000: Cannot Save a Blank Record in a Table or Form
- ACC2000: Lookup Wizard Error: You Already Have a Field Named...
- ACC2000: Spelling Checker Ignores Misspelled Uppercase Words
- ACC2000: AutoLookup Field Returns Unexpected Value in Word Mail Merge
- ACC2000: TransferText Ignores Indexes in Import Specification
- ACC2000: Table in a Microsoft Access Project Cannot Be Updated
- ACC2000: Operational Range for Dates in Microsoft Access 2000
- ACC2000: Parameter Prompt If LinkMasterFields or LinkChildFields Contains Table Name
- ACC2000: You Receive No Warning When a Number Is Too Large for a Single Data Type
- ACC2000: GoToControl to Control with Focus in AfterUpdate Ignored
- ACC2000: How to Use In-place Activation with OLE Objects
- ACC2000: Can't Import Single Cell Excel Named Range
- ACC2000: Hiding Control on a Page Doesn't Hide Control's Label
- ACC2000: Option Buttons on a Data Access Page Must Have Name and ID Property Values
- ACC2000: Optional Fields Not Added to Database Made by Database Wizard
- ACC2000: Error Message Clicking Start Page on Web Toolbar
- ACC2000: Can't Use ENTER to Move Data to Next Line of Wizard
- ACC2000: Two Device Independent Bitmaps in Paste Special Dialog Box
- Programmatically Populated Combo Box or List Box Is Not Sorted in the Order Expected
- Expressions to count yes, no, and other responses in Access
- PRB: CompactDatabase Method Requires Locale to Convert 2.0 MDB
- Tips for optimizing Access 97 queries on attached SQL tables
MDAC (ADO, OLEDB, ODBC)
- How To Logical Values Must Be Sent to SQL Server as 1 or 0
- How To Get XML Representation Of an ADO Recordset in Visual Basic
- How To Get More Information on the ODBC Call Failed Error
- How To Generate an ODBC Trace with ODBC Data Source Administrator
- How To Insert NULL Data with OLE DB SDK Interfaces
- How To Ensure Jet 3.5 Is Installed Correctly (Part II)
SQL Server 2000
- INF: MDX: How to Query for the 10 Best Customers and the Top 5 Products for Each Customer
- INF: How to Calculate the Cumulative Value of a Measure
- FIX: Query Analyzer Hangs After You Drag & Drop Files Into the Query Editor and You Close One of the Newly Created Windows
- FIX: SQL Server Cluster Resource Fails to Come Online Until Cluster Service Is Restarted
- INF: Use of Multiple Hierarchies Versus the Creation of Separate Hierarchies
- INF: Creating Databases or Changing Disk File Locations on a Shared Cluster Drive on Which SQL Server 2000 was not Originally Installed
- PRB: Long Running OLAP Queries do not Return Data When Connected Through HTTP
- PRB: Duplicate Rows in Dimension Tables Inflate Measures
- FIX: Failover of a SQL Virtual Server Causes Problems with Active Directory Integration
- INF: The Impact of Using Changing Dimensions
- INF: How to Create a Derived Measure Instead of a Calculated Member
- BUG: Replication Transactional Pull Subscriptions Fail with "Error 14262:The specified @job_id could not be found" Error Message
- INF: Different Kinds of Analysis Services Timeouts
- INF: File Size Limitations For Use of Archive/Restore for OLAP
- BUG: You Receive an Error Message If the Member Caption Is Different from the Member Name
- FIX: Inconsistent Results Reported by TOP N Using Full-Text CONTAINSTABLE
- PRB: Drillthrough Queries Return More Rows than Expected If Cube Schema Is Optimized
- FIX: Updates to Distributed Partitioned Views May Return Incorrect @@ROWCOUNT Value
- FIX: Queue Reader Agent Fails if the Distributor is a Clustered SQL Server
- BUG: Virtual Setup Stops Responding (Hangs) if Disk and Group Name Are the Same
- FIX: "Update Index in Background" Option in Change Tracking May Not Work if Very Low Disk Space Detected
- PRB: How to Manage Client Connectivity to Both SQL Server 2000 Virtual Servers After an Active/Active Cluster 7.0 Upgrade
- Failures may occur during cube processing if you select a member key column that is not correct
- INF: NoRemapPipes Error Message Occurs in System Log when You Use SQL Server 2000 on a Windows 2000 Cluster
- PRB: Undocumented Filter Syntax for IReposQuery::GetCollection Method
Week Ending July 11, 2004
Microsoft Access
MDAC (ADO, OLEDB, ODBC)
SQL Server 2000
Week Ending July 18, 2004
Microsoft Access
MDAC (ADO, OLEDB, ODBC)
SQL Server 2000
Week Ending July 25, 2004
Microsoft Access
- ACC2000: How to Use Data from Microsoft Access in a WordPerfect Mail Merge
- ACC2000: Query with Time Criteria Returns No Records from Microsoft SQL Server
- ACC2000: Graph Object Appears Blank in Form View
- ACC2000: Saving Objects in Large Database Slower Than in Earlier Versions
- ACC2000: Installing Access 2000 Overwrites Existing Access Shortcut
- ACC2000: Can't Create ADP or Page Using Windows Shortcut Menu
- How to troubleshoot problems that you may experience when you try to print to a local printer by using Office programs in Windows XP
- ACC2000: Logon Dialog Box Appears When Using Wizard or Add-in in ADP
MDAC (ADO, OLEDB, ODBC)
- Oracle ODBC driver returns SQL_DECIMAL for all convert function calls
- HOWTO: DAO: Attach to and Create QueryDefs on ODBC Tables
SQL Server 2000
- How to establish and enforce encrypted multiprotocol connections in SQL Server 2000
- FIX: An access violation exception may occur when you use PDH APIs to collect performance data for several instances of SQL Server at the same time
- INF: How to Reschedule a DTS Package
- BUG: Property Changes in the Merging Changes Tab of an Indexed View Article Are Not Saved
- FIX: Books Online Incorrect About Default Value of @terminate for SP_CHANGE_PRIMARY_ROLE
- PRB: Restoring Archive from Server with Metadata Format to Server with Access Repository Fails
- A message stating that an instance of SQL Server is vulnerable to virus attacks is logged in the application event log when you install SQL Server 2000 or MSDE 2000 on a computer that is running Windows XP Service Pack 2
- PRB: SQL Server Agent does not start and displays error 18456
Alrak's Course Resources ©2002-2007 Karla Carter. All rights reserved. This material (including, but not limited to, Mini-lectures and Challenge Labs) may not be reproduced, displayed, modified or distributed without the express prior written permission of the copyright holder. For permission, contact Karla.