Print Page | Close Window

RemoteDb.mdb

Printed From: Roger's Access Library
Category: Other Download Libraries
Forum Name: Tejpal, A.D.
Forum Description: A.D. Tejpal's Library
URL: www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=59
Printed Date: 18 Dec 2017 at 3:17pm


Topic: RemoteDb.mdb
Posted By: A.D. Tejpal
Subject: RemoteDb.mdb
Date Posted: 07 Jul 2008 at 11:06pm
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 -




Print Page | Close Window