Latest MS Access Knowledge Base Articles

Courtesy of KBAlertz.com:

How to use TOP N Query from Microsoft Access 2.0 in VB (147724) - One of the new types of queries added to Microsoft Access version 2.0 for Windows is called a TOP N query. If you have Microsoft Access version 2.0 or higher, and Microsoft Visual Basic for Windows version 4.0 and higher, you can use this type of ...

How to work with the Outlook E-mail Security Update in an Access database (263084) - Describes that you may receive "A program is trying to automatically send e-mail on your behalf" message when you run the SendObject macro action. Or, you may receive a "run-time error '2293'" when calling the SendObject VBA method in Access.

Cannot edit or update a record on an Access form (209571) - You may not be able to edit a record on a form even though the AllowEdits property of the form is set to Yes . When you try to update data on the form, you may receive the following error message: This Recordset is not updateable. If the form is ...

ACC2000: How to Use a Query to Format Data for a Mail Merge (197520) - In a Microsoft Access table, if you've added formatting to the numbers in a Number field, and you send that data to Microsoft Word through a mail merge, the numbers will lose their formatting when they appear in Microsoft Word. In a mail merge, ...

Objects are removed when you convert partial replicas from Access 97 to Access 2000 (263171) - You convert a Microsoft Access 97 partial replica to Access 2000. Then you synchronize the Access 97 partial replica with a converted full replica or with Design Master. All the database objects are removed from the converted partial replica ...

No records returned in query between an Access 2000 table and a linked Access 97 table (244137) - No records are returned for a query that joins a Microsoft Access 2000 (Jet 4.0) table to a linked Microsoft Access 97 (Jet 3.5) table. This happens even though you are certain that there are matching records. This behavior can occur only when all ...

You receive a "Not a Valid Password" error message when you open an Access 97 database in Access 2000 (246033) - When you open a Microsoft Access 97 database in Microsoft Access 2000, and if the database password has 14 or more characters, you may receive the following error message: Not a valid password. To work around this behavior, follow these steps: ...

A newly created Access 97 database is not secure when you convert a security-enhanced Access 2000 database to Access 97 format (198986) - When you convert a security-enhanced Microsoft Access 2000 database to Microsoft Access 97 format, the newly created Access 97 database is not secure. Permissions are reset to their defaults in the newly created Access 97 database. This problem ...