Roger's Access Library Homepage
Forum Home Forum Home > Other Download Libraries > MS Access MVP Libraries > Tejpal, A.D.
  New Posts New Posts RSS Feed - RemoteDb.mdb
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

>
Want a good read? Try The Summer of His Life (available on Amazon!)

RemoteDb.mdb

 Post Reply Post Reply
Author
Message
A.D. Tejpal View Drop Down
Microsoft MVP
Microsoft MVP


Joined: 30 Jun 2008
Status: Offline
Points: 192
Post Options Post Options   Thanks (0) Thanks(0)   Quote A.D. Tejpal Quote  Post ReplyReply Direct Link To This Post Topic: RemoteDb.mdb
    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: uploads/37/RemoteDb.zip

--

Email: adtejpal@gmail.com
Back to Top
Sponsored Links
>
Want a good read? Try The Summer of His Life (available on Amazon!)

Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.03
Copyright ©2001-2019 Web Wiz Ltd.