Microsoft Knowledge Base Article Links
From the Database Community Forum
June 2004
Week Ending June 4, 2004
Microsoft Access
- You may receive the "Can't find the database you specified" error message when you open an Access database by using a shortcut
- ActiveX control that is contained in an Access form does not appear when the design-time license is not available
- Access 2002 post-Service Pack 3 hotfix package: May 7, 2004
- Incorrect object dependencies information appears for database objects in a read-only database
MDAC (ADO, OLEDB, ODBC)
SQL Server 2000
- SQL Server clients are authenticated as guests if Simple File Sharing is enabled
- FIX: An invalid cursor state occurs after you apply Hotfix 8.00.0859 or later in SQL Server 2000
- You receive a "Command line option syntax error" error message when you install SQL Server 2000 SP3
- FIX: A CHECKDB statement reports corruption after SQL Server transfers sql_variant data in SQL Server 2000
- FIX: The dynamic Snapshot Agent may fail when you use a dynamic snapshot for merge publications in SQL Server 2000
- SQL Server 2000 Windows CE Edition frequently asked questions
- FIX: You may receive a BPool::Map warning when you create or rebuild indexes by using the awe enabled configuration option
- You receive an error message in the Reporting Services trace log when you restart the Report Server service after you change the user account that is used to run the Report Server service
Week Ending June 12, 2004
Microsoft Access
- You cannot use the MSODSC control when you insert an Office Chart 11.0 control in a data access page
- How to reset the page number and the total page count for each group in a Microsoft Access report
- Description of the Office XP post-Service Pack 3 hotfix package: May 8, 2004
- Programmatically modifying an action query in an Access database invalidates the digital signature of the Access database
- The AutoExpand property may not work when ANSI-92 syntax is enabled and the Combo Box RowSource does not use DISTINCT values
- Administrative installation of the Access Run-time Application is not successful
- "The Text You Entered Isn't an Item in the List" error message when you programmatically add a new record to a table by using the NotInList event of the Combo Box on a form
- Compilation is not successful when you convert a macro to a module
- BUG: Field size is changed when you copy and paste a table in an Access project
- Data remains unchanged when you modify dates by using the Calendar Control
- "Undefined Function '{FunctionName}' in Expression" error message when you open a data access page in Internet Explorer
- Jet 4.0 OLE DB Provider requires a Jet 4.0 system database
- Description of the Access 2002 post-Service Pack 3 hotfix package: May 26, 2004
MDAC (ADO, OLEDB, ODBC)
- FIX: SQLStatistics function returns incorrect sort order sequence
- Release manifest for MDAC 2.5 Service Pack 3 (2.53.6200.2)
- Release manifest for MDAC 2.6 (2.60.6526.3)
- Release manifest for MDAC 2.6 Service Pack 1 (2.61.7326.6)
- Release manifest for the MDAC 2.7 Service Pack 1 Refresh (2.71.9040.2)
- Release manifest for the MDAC 2.6 Service Pack 2 Refresh (2.62.7400.1)
SQL Server 2000
- Maximum number of database users and roles that you can create
- How to set up a linked server to a Sybase database server and troubleshoot problems that may occur
- FIX: The xp_logininfo procedure may fail with error 8198 after you install Q825042 or any hotfix with SQL Server 8.00.0840 or later
- FIX: An AWE system uses more memory for sorting or for hashing than a non-AWE system in SQL Server 2000
- FIX: A memory leak occurs when you run queries in the same connection in Analysis Services
Week Ending June 19, 2004
[Copied directly from the KBAlertz weekly newsletter]
| Access |
| 209534 Database normalization basics |
| 824261 Jet 4.0 OLE DB Provider requires a Jet 4.0 system database |
| 833864 Description of the Access 2002 post-Service Pack 3 hotfix package: May 26, 2004 |
| 843189 Your converted database may not function as expected when you convert an Access database in Access 2002 from an earlier version of Access |
| 250616 ACC2000: How to Use Data Transformation Services (DTS) to Export Data from a Microsoft Access Database to a SQL Server Database |
| 830814 Description of the proofing tools for the Italian version of Office XP post-Service Pack 2 hotfix package: November 7, 2003 |
| 842780 Description of the Access 2002 post-Service Pack 3 hotfix package: June 2, 2004 |
| 172300 ACC97: Command Bar Wizard Available in Download Center |
| 867493 Your custom program may quit and you receive an error message when you add rows to a subform in your custom Access 2002 program on a Tablet PC computer |
| 841365 Description of the Access 2002 post-Service Pack 3 hotfix package: May 27, 2004 |
| 142466 Achieving Optimal Performance Paper Available in Download Center |
| 150895 ACC95: Microsoft Access 95 Sample Forms Available in Download Center |
| 238445 OFF97: Office 97 ODBC Driver Vulnerability Security Update |
| 232577 ACC2000: Cannot Administer SQL Server Rules Through Access Client-Server User Interface |
| 128382 UT2: Access Upsizing Tools Information Available in Download Center |
| 129523 ACC2: Tech*Ed 95: Sessions on Database Building Blocks |
| 143270 ACC: Creating and Testing Add-ins Paper Available in Download Center |
| 142467 ACC95: Splitting Applications Paper Available in Download Center |
| 148544 ACC95: Viewable WzTool70.mda Code Available in Download Center |
| 172182 ACC97: Balloon Wizard Available in Download Center |
| 128383 ADT2: Updated ADT License Agreement Available in Download Center |
| 139372 ACC95: Porting 16-bit Applications Available in Download Center |
| 139480 ADT95: ADT for Windows 95 Product Information Available in Download Center |
| 129529 ACC2: Tech*Ed 95: Sessions on Using MS Query and ODBC |
| 163603 ACC97: Files for Testing System DSN Available in Download Center |
| 128388 ACC2: Rushmore Query Optimization Paper Available in Download Center |
| 128385 ACC95: Jet & ODBC White Paper Available in Download Center |
| 129524 ACC2: Tech*Ed 95: Sessions on MS Office Integration Techniques |
| 128384 ACC: Choosing Database Tools White Paper Available in Download Center |
| 113557 ACC2: Tech*Ed 94 Sessions on Modules and Access Basic |
| 139486 ACC95: Table Analyzer Wizard Q & A Available in Download Center |
| 139485 Replication Q & A Available in Download Center |
| 148553 ACC95: Viewable Wizlib70.mda Code Available in Download Center |
| 129530 ACC2: Tech*Ed 95 Sessions on QueryTips and Tricks |
| 113560 ACC2: Tech*Ed 94 Sessions on ODBC Issues in MS Access 2.0 |
| Access 2000
|
| 232379 ACC2000: How to Create and Use Temporary Tables with Access Client Server |
| 241743 ACC2000: "Access 2000 Upsizing Tools" White Paper Available in Download Center |
| 235359 ACC2000: Implementing Query-by-Form in an Access Project |
| 233488 ACC2000: Unable to Synchronize with MSDE/SQL Server on Windows 95 or 98 |
| 227211 ACC2000: Upsizing Wizard Does Not Create Constraint for AllowZeroLength Property |
| 209523 ACC2000: How to Determine Version of INSTCAT.SQL File on Server |
| 234346 ACC2000: Cannot Modify Statement Permissions in an Access Project |
| Access 2003
|
| 830815 Description of the proofing tools for the Italian version of Office 2003 hotfix package: June 1, 2004 |
| Access 97 |
| 177972 ACC97: Neatcd97.mdb Available in Download Center |
| 172183 ACC97: Domain Function Wizard Available in Download Center |
| 165836 ACC97: Graph 97 Chart Object Does Not Update Display Correctly |
| 170837 ACC97: Status Bar Continues to Display "Calculating..." |
| 171207 ACC97: Removing Replicated Module Causes Automation Error |
| 172162 ACC97: "Name Conflicts..." Error When Opening Replica |
| 166634 ACC97: Filter By Form Example for Run-Time Applications Available in the Download Center |
| 167849 ACC: 'TMP%#MAU' Error Generated When Opening Linked Table |
| 172164 ACC97: Data in OLE Object or Memo Field Missing from Replica |
| MDAC (ADO, OLEDB, ODBC)
|
| 818539 FIX: A deadlock occurs when you repeatedly load and then unload the Dbnetlib DLL |
| 178875 ORALONG.EXE: Use RDO with Oracle LONG/LONG RAW Datatypes |
| 245745 SAMPLE: RDS_Comp.exe Demonstrates How to Use the RDS.Dataspace Object from Client Script |
| SQL Server 2000
|
| 831999 FIX: An AWE system uses more memory for sorting or for hashing than a non-AWE system in SQL Server 2000 |
| 839980 How to use a script to programmatically open ports for SQL Server to use on systems that are running Windows XP Service Pack 2 |
| 838460 FIX: The xp_logininfo procedure may fail with error 8198 after you install Q825042 or any hotfix with SQL Server 8.00.0840 or later |
| 841856 FIX: A memory leak occurs when you run queries in the same connection in Analysis Services |
| 117559 INFO: How to Correlate Spid, Kpid, and Thread Instance |
| 841627 FIX: SQL Server 2000 may underestimate the cardinality of a query expression under certain circumstances |
| 272439 PRB: SQL 2000 Profiler Doesn't Capture SHOWPLAN Events if the BinaryData Data Column Is Not Captured |
| 843026 BUG: You receive an error message when you try to deny access to a dimension member for a cube role by using a custom rule in Analysis Manager |
| 811188 FIX: The merge replication agent stops responding when you perform merge replication between a SQL Server database and a SQL Server CE database by using a custom conflict resolver |
| 842422 How to create a bar graph that has a trend line in a chart in Report Designer |
| 867650 You cannot add SQL Server components to an existing virtual instance of SQL Server by running the Setup program |
Week Ending June 26, 2004
Microsoft Access
- ACC2: Neatcod2.mdb Available in Download Center
- ACC95: Neatcode.mdb Available in Download Center
- ACC95: Viewable Wzcnf70.mda Code Available in Download Center
- ACC95: Using Updatable Queries White Paper Available in Download Center
- ACC2: Parameter Typing Utility Available in Download Center
- ACC2: Sample to Undo Changes in Forms Available in Download Center
- ACC2: Multiuser Wizards Available in Download Center
- ACC2000: "Can't Find the Database You Specified" Error When Starting Access 97 After Upgrade to Office 2000
- ACC2000: Add To Favorites Creates Different Names for Hyperlinks
- ACC2000: Upsizing Report Incorrectly Shows Field as Varchar
- ACC2000: "Can't Encrypt Database" Error Message Is Misleading
- ACC2000: References Not Imported with Objects from Another Database
- ACC2000: Null Value Does Not Pass Validation Rule
- ACC2000: Hyperlink Starts New Access or Internet Explorer Instance
- ACC2000: Error Refreshing Text File with Linked Table Manager
- ACC2000: Determining Which User Has Opened Database Exclusively
- ACC2000: Can't Use Any Wizard While in Break Mode of a Module
- ACC2000: Clicking Print Preview While Previewing Closes the Object
- ACC2000: Previewing Records That Will Be Affected by Action Query
- ACC2000: Report Snapshot with Graphic Truncated in Windows 95/98
- ACC2000: OutputTo Message Box Displays Incorrect AutoReport Name
- ACC2000: Cannot Enforce Referential Integrity in Relationship
- ACC2000: How to Use Select Queries Without Join Lines
- ACC2000: How to Group Column Headings in a Crosstab Query
- ACC2000: Using Query to Return Every Nth Record from a Table
- ACC2000: List Box Column Property Receives Incorrect Row Information
- ACC2000: Exported Query Expression Truncated at 255 Characters
- ACC2000: Error Updating Field When Adding New Record to Form
- ACC2000: Pages Option Button Is Not Available in CommonDialog Control
- ACC2000: How to Delete Duplicate Records from a Table
- ACC2000: OLE Object Error When Setting the RowSourceType Property
- ACC2000: How to Limit Input in Unbound Text Box
- ACC2000: SetWarnings Action Works Only While Macro Is Running
- ACC2000: Sample Query to Print One Label for Two People at the Same Address
- ACC2000: FontName Property of Navigation Control on Data Access Page Is Not Updated as Expected
- ACC2000: Formatted Colors Do Not Appear in Text
- ACC2000: Some Add-Ins Do Not Have Help File Available
- ACC2000: Make-Table Query Does Not Copy All Table Properties
- ACC2000: The Time Cards Subform Is Not Filtered with New Records
- ACC2000: Error Using Database Documenter If Objects Are Open
- ACC2000: Synchronize with Replicas Before You Change Design Master Schema
- ACC2000: Bold Font Style Not Exported Using Analyze It with MS Excel
- ACC2000: Exporting Date Fields to Text Includes Time Format
- ACC2000: "Expected Function or Variable" Error Message
- ACC2000: DblClick Event Appears to Not Work
- ACC2000: HTML: Search for Hyperlink Fails with Specified Criteria
- ACC2000: How to Use Visual Basic to Change the Application Title
- ACC2000: Invalid Length for Fixed-Length String - Exceeds 64-KB Limit
- ACC2000: Cannot Hyperlink to Documents with # in the Name
- ACC2000: Copy/Paste from Datasheet Field Pastes Field Name
- ACC2000: Unbound Data Access Pages Cannot Contain Fields Based on an Expression
- MOD2000: How to Distribute a Secured Database
MDAC (ADO, OLEDB, ODBC)
SQL Server 2000
- FIX: Cannot Execute SELECT COUNT(*) Against DB2 on Mainframe Using Four-Part Name
- Initial snapshot generation may fail if network redirector caching is enabled
- Documentation errors and corrections in Reporting Services Books Online topics about debugging and deploying custom assemblies and report server extensions
- How to enable ports on Windows XP SP2 for Analysis Services and SQL Server 7.0 OLAP Services
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.