Professional White Papers

Secfaq.exe Microsoft's Security FAQ whitepaper

reldes00.exe Microsoft's Designing a Database -- Understanding Relational Design

ReplFAQ2K.zip Microsoft's Replication whitepaper

Migrating From DAO to ADO.zip Migrating from DAO to ADO

av97doc.EXE Microsoft's Everything You Need to Know About Data Access

Conv2000.exe Microsoft's Access2000 Conversion whitepaper

Conv2002.exe Microsoft's Access2002 (XP) Conversion whitepaper

Q290576 ACC2000: How to Install Access 97 and Access 2000 on the Same Computer

Q290576 Running Multiple Versions of Microsoft Office

BuildingAStringExpression.zipExplains how to create a string which has an embedded string
(excerpted from "Microsoft Access 2.0 How-To CD" (by Getz, Feddema, Gunderloy, and Haught)

Fundamental Microsoft Jet SQL for Access 2000

Intermediate Microsoft Jet SQL for Access 2000

Advanced Microsoft Jet SQL for Access 2000

Setting Global Options Programmatically in Access 2000

WORKING WITH LARGE PROGRAM DATABASES IN ACCESS 97

 Roger's White Papers
(Just stuff I've learned along the way.)

AmbiguousOuterJoins.zip  Explains what Ambiguous Outer Joins are, how to recognize them and how to solve them.

BangVSDot.zip Explains the difference in usage between the Bang (!) and Dot (.) in DAO.

ConvertingAccessDatabases2to97.zip  Introduction to converting Access 2.0 database to Access 97

ConvertingAccessDatabases-AdvancedTopics.zip   More on converting Access 2.0 to Access 97

CurrentDBvsDBEngine.zip  Explains the difference between CurrentDB and DBEngine (0)(0)

DecompilingDatabases.zip  Explains the undocumented Decompile option in Access 97

MissingReferences.zip  Explains why built-in functions sometimes stop working and how to fix it.

NullZeroEmpty.zip  Explains the differences between Null, Zero, and Empty

Access EXE.doc  Can you create an EXE from an Access database?

  Other Developer's White Papers

CurrentDB vs DBEngine and Access 2000 Here is a problem that I ran into when converting from Access97 to Access2000.   Rod Archibald

Fix Corrupt Access Database Here is a list of tips and tricks in a checklist format to help those with a corrupt database.   Jerry Whittle, 3313 Saratoga Dr, Belleville, IL 62221 USA whittlej@apci.net

 Access 97 multi back end using NT security Procedure to enable MS Access 97 to run in a multi back-end/front-end, multi-user environment using NT security only.
        Keith Harvey  harvey@hunterlink.net.au
 

Home