Microsoft Year 2000 Readiness Disclosure & Resource Center

Product Summary

Product: Access 2000 Version: 9.0 Category: Compliant Operating System: 32-Bit Win Language: Serbian Release Date: N/A Operational Range: 01 Jan 0200 - 31 Dec 9999 Prerequisites: None Product Dependencies: Windows 95, Windows 98, Windows NT 4.0 (no specific Service Pack is required, however Service Pack 4 is recommended), Windows 2000, OLE Automation Technology, SQL Server, Internet Explorer, Microsoft Data Access Components (MDAC) Clock Dependencies: System clock Last Updated: 28 Sep 1999

Product Details

Product Maintenance: While Microsoft continues to recommend that customers install the most current Service Pack/Release for non-Year 2000 reasons, we understand that, for many reasons, this may not be possible. In order to aid our customers' Year 2000 efforts, Microsoft intends to maintain Access 2000 version 9.0 as compliant through January 1, 2001. Newer Service Packs are also to be maintained as compliant, and may include additional non-Year 2000 updates. This is intended to minimize the Year 2000 as a reason to upgrade. How the product handles dates: Storage. Microsoft Access 2000 stores the Date/Time data type as a double-precision, floating-point number (up to 15 decimal places). The integer portion of the double-precision number represents the date; the decimal portion represents the time. See Knowledge Base article Q130514 for more information. Access 2000 relies on the Jet database to store data. It uses shared Visual Basic for Applications (VBA) components to perform calculations on Date/Time data. Formatting. If an input mask is not used, which is the default behavior, dates can be entered in 2- or 4-digit formats. Dates can be input in predefined and custom input formats via an input mask. Input masks enforce date entry in a particular format. Input mask predefined formats include a short date format, which forces users to enter dates in a 2-digit format. A custom input mask can be created to limit date entry to only 4-digit years. Access does not require an input mask to enter dates. Dates can be displayed in predefined and custom formats by using the Format property and Format function. By default, dates are displayed in General Date format, which is a combination of short date and short time, as specified in the Regional Settings in Control Panel. The General Date format will display dates inside of the 1930-2029 date window with two-digit years, dates outside this window will be displayed with four-digit years. Custom formats can be created to display years as 4 digits. By using the following procedure, date fields and controls can be forced to display 4-digit yearsùwhich may help to ensure that the century of a particular date is correct. On the Tools menu, click Options, and then click the General tab. Under Use four-digit year formatting, do one of the following: To force display of 4-digit years at the database level (in the current Access database or Access project), select the This database check box. To force display of 4-digit years at the program level (in all Access databases and Access projects), select the All databases check box. Selecting one of these check boxes changes only how dates are displayedùnot the data itself. These options override Format property settings for individual fields and controls. The All databases option can also be set by using the following registry key: [HKEY_CURRENT_USER\Software\Microsoft\Office\9.0\Access\Settings] "Four-Digit Year Formatting All Databases"=DWORD:00000001 Two-digit shortcut handling: Dates are interpreted by using the automation libraries. For more information, see The Automation Libraries and the Year 2000 white paper. Common date usage errors: Input Masks. Using the short date input mask will limit the ability of users to enter dates outside of the 2-digit-year shortcut range. Date/Time Data Type. Use Date/Time fields in tables to store date data. Avoid using Text fields to store date data. Date Display. Avoid the use of the short date format (for example, m/d/yy). Use a 4-digit-year format to display dates such as the long date format, the short date format in conjunction with the Regional Settings in Control Panel, or a custom format to display the 4 digits of the year (for example, m/d/yyyy). Literal Dates in Queries. Use a 4-digit year when entering date criteria into the SQL view of the Query designer. Date criteria entered into the Query designer grid will be expanded to 4 digits. Exporting Text. Text export method, including the use of VBA TransferText, should be set for export of 4-digit years. Testing guidelines and recommendations: In general, avoid testing in a production environment because side effects with non-compliant products cannot be predicted. The following areas can be looked at to verify that dates are being properly used. The following table can be used to guide testing of Access 2000 within your organization. Functionality Areas affected Testing notes TransferText, Import/Export Tables, queries, forms, reports, macros, modules Import and export of text files is available using the menus, the Transfer Text macro action, and in Visual Basic for Applications (VBA) code using the TransferText method. Date data in 2- and 4-digit-year formats can be imported and exported using an Import/Export specification. By default, dates are exported in a 2-digit-year format. The 4-digit-year format can be selected when creating an Import/Export specification. Indexes Tables Date and time values can be indexed and can require unique values. Format Tables, queries, forms, reports, modules Provides formatting of Date/Time data in tables, queries, form, reports, and VBA code. Exists as a property for Table, Query, Form, and Report fields. Also implemented as an intrinsic function, Format(). Formats based on Regional Settings in Control Panel include long date, short date, and long time. Access intrinsic formats include general date, medium date, medium time, and short time. Custom formats include any combination of month, day, year, and time. Input Mask Tables, queries, forms, reports, modules Limits user data entry to specific values. Values for input mask are derived from combinations of token characters, such as 0, 9, and X, similar to custom format properties. However, the validation and formatting of date data is done after the user has entered the data into the input masked field. Wizard-defined input masks related to dates include short date, medium date, short time, medium time, and long time. Validation Rule Tables, queries, forms Verifies data entered by the user. The Validation Rule expression can use Date/Time data from fields and perform comparisons on calculated date values. Aggregate Queries Queries Users can group and sort queries on Date/Time fields. Aggregate queries also allow Date/Time fields to have totals calculated for the group date. The calculations allowed are Sum, Avg, Min, Max, Count, StDev, Var, First, and Last. Domain Functions Queries, forms, reports, modules Performs lookups and calculations on data and return the results. These functions are DAvg, DCount, DLookup, DFirst, DLast, DMin, DMax, DStDev, DStDevP, DSum, DVar, and DVarP. Insert Date & Time Forms, reports Inserts a calculated field that uses the Format function on the value of Date(). Charting Forms, reports Forms and reports can display charts that display Date/Time data based on a record source provided by Access. Calendar Control Forms, reports, modules Value property allows user to get and set dates on the calendar. The year is always displayed as 4 digits. Report Grouping Reports Reports can group and sort Date/Time data based on Each Value, Year, Qtr, Month, Week, Day, Hour, and Minute. Day(), Month(), Year(), WeekDay() Queries, forms, reports, modules Parses Date/Time data. Date(), Now() Queries, forms, reports, modules Returns date, and date and time DateAdd(), DateDiff() Queries, forms, reports, modules Performs calculations on Date/Time data. LastUpdated, DateCreated properties All database objects Date/Time stamp of last update and object creation, provided by Data Access Objects (DAO). CDate() Queries, forms, reports, modules Valid ranges are -657434 (1/1/100) to 2958465 (12/31/9999). Time is stored in the decimal portion of the number. More information: Click the links below to Knowledge Base articles for more information about date-related issues. How to articles HOWTO: Prepare Visual Basic Applications for the Year 2000, Q162718 ACC: How to Convert Julian Days to Dates in Access and Back, Q162745 ACC: How to Find the Number of Days in a Month, Q109703 HOWTO: Change the Short Date Format from Visual Basic, Q168793 ACC: How to Determine If a Date Falls on a Weekend or Holiday, Q149127 ACC: How to Format Dates As U.S. Regardless of Regional Settings, Q149095 ACC: How to Convert Short Time Format to Different Formats, Q141536 ACC: How to Get the Fiscal Year/Month of a Particular Date, Q132101 ACC: How to Display Only the Last Two Digits of Any Year, Q95907 ACC: Converting Julian Dates with Visual or Access Basic Code, Q92816 ACC: Functions for Calculating and Displaying Date/Time Values, Q88657 ACC: Function to Get Date of Monday Prior to Current Day. Q103138 ACC: Two Functions to Calculate Age in Months and Years, Q100136 Informational articles ACC: Storing, Calculating, and Comparing Date/Time Data, Q130514 ACC: Date/Time Data Type Provides Current Year Automatically, Q98802 ACC: Calendar Control Adds One Day When Time Is After 12:00 PM, Q169599 ACC: Years 00-29 Default to Year 2000 When Typed as M/D/YY, Q155669 ACC: How Windows Regional Settings Affect Microsoft Access, Q142009 Other date issues ADT/ODE: Calendar Control Cannot Format Individual Dates, Q114832 ACC: Operation Stops When Editing Attached SQL Tables, Q96897 ACC: Can't Paste Append Using Input Mask Based on Short Date, Q160575 ACC: Importing Text File with Dates in DDMMMYY Format (95/97), Q159323 ACC: Conversion Errors Importing Dates with Different Formats, Q142184 Incorrect Date Value Added to Properties Custom Tab, Q130580 ACC: Using Format() and Month() Returns Incorrect Month, Q106290 ACC: Exporting Date Fields to Text Includes Time Format, Q103174 ACC: Query w/Time Criteria Returns No Records from MS SQL Server, Q173097 Access 2000 uses a number of Microsoft Office 2000 shared files for the implementation of dialogs and toolbars, task automation, online help, installation, graphics, file find and file I/O. For additional information that is appropriate for Access 2000, please refer either to the document for the particular Office version that this application came with, or, in the case of a standalone product, to any version 2000 Microsoft Office document.

Return to Search Screen

If after reviewing this information you have additional questions related to this product, click here.

ANY MICROSOFT YEAR 2000 STATEMENTS MADE TO YOU IN THE COURSE OF PROVIDING YEAR 2000 RELATED UPDATES, YEAR 2000 DIAGNOSTIC TOOLS, OR REMEDIATION SERVICES (IF ANY) ARE SUBJECT TO THE YEAR 2000 INFORMATION AND READINESS DISCLOSURE ACT (112 STAT. 2386). IN CASE OF A DISPUTE, THIS ACT MAY REDUCE YOUR LEGAL RIGHTS REGARDING THE USE OF ANY SUCH STATEMENTS, UNLESS OTHERWISE SPECIFIED BY YOUR CONTRACT OR TARIFF.

This site is being designated as a Year 2000 Readiness Disclosure and the information contained herein is provided pursuant to the terms hereof and the Year 2000 Information and Readiness Disclosure Act.