Microsoft Access 2000 supports one of two back-end technologies: MSDE and Microsoft Jet. With the release of Microsoft® Access 2000, users and developers have the choice of two data engines in the product: an improved version of the existing Access engine, called Microsoft Jet, or the Microsoft Data Engine (MSDE), which is compatible with Microsoft SQL Server™ 7.0. The default data engine for Microsoft Access is Jet.
Microsoft Access 2000 Versions
Microsoft Access Database Field Support
Query Support in Microsoft Access
Linked Databases in Microsoft Access
Relative and Absolute Path Names for Microsoft Access Databases
Accessing Microsoft SQL Server Tables through Microsoft Access Queries