General

Y2K

Although Access 2000 generally interprets 21st century dates with two-digit

years correctly, I strongly recommend that you take advantage of the new Use

Four-Digit Year Formatting option in Access to avoid all confusion. When you

choose this option, Access displays four-digit years in datasheets, forms, and

reports. It also converts whatever you type in an expression (such as Criteria in

a query) to display four digits. Choose Options from the Tools menu, and then

click the General tab to set this option.

I also recommend that you change your Regional Settings in Windows Control

Panel to display a four-digit year in the Short Date Style. This will assist your

entry and display of year values in other applications -- such as Access 97.

Also check out this excellent whitepaper at FMS, Inc.:

If you open one of the built-in toolbars in a context in which the toolbar

would not normally be open, the toolbar remains open until you close it. For

example, if you open the Customize dialog box while the focus is on the Data-

base window and then open the Form Design toolbar, the toolbar remains

open no matter what you are doing in Access. Likewise, if you close a toolbar

in a context in which that toolbar is normally open (for example, if you close

the Formatting toolbar in a Form window in Design view), that toolbar will

remain closed until you open it again within the usual context or from the

Customize dialog box.

When you copy a built-in menu (either from an available menu bar or from

the Built-In Menus category), Access does not make an independent copy of

the original. So, if you copy a menu and then change some of its properties

(for example, you delete one of the commands from the menu), you’re also

affecting the built-in menu. This is why you must use the New Menu command

for the first menu level (File, Edit, View, etc.) on a custom menu bar. If

you were to copy the originals and delete unwanted commands from the

copies, you’d be deleting them from the built-in menus as well.