This sample db demonstrates handling of objects and data in an external db, 
without setting up any library reference or table link. This feature allows flexibility in 
deployment, without having to worry about missing references or links.

Following tasks are covered (using the Local db).
    (a) Preview a report belonging to remote db.
    (b) Background printing of a report belonging to remote db. After completion of 
         print job, the remote db gets closed automatically. No distraction to the user of 
         local db
    (c) Open a form in remote db.
    (d) Run a local query using data from table existing in remote db.
 
Note - In Access 2000, the start up option for displaying database window should 
be kept enabled for smooth execution of (a) to (c) above.

References - DAO 3.6

Download Access XP & 2K:  http://www.rogersaccesslibrary.com/forum/uploads/37/RemoteDb.zip -