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 - ExternalDbAutomation.mdb
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Please consider donating $1 per sample downloaded, (find out why here)


 Post Reply Post Reply
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: ExternalDbAutomation.mdb
    Posted: 09 Jul 2008 at 10:43pm
The sample set consists of two mdb files, representing local and external db's 
respectively. Access XP version incorporates programmatic insertion of password 
argument for opening the external db (In earlier versions, password argument is not 
available for OpenCurrentDatabase method). 
    So long as both db's are in the same folder, the local db will automatically detect
the path of external db
    Clicking the command button captioned "Go To External Db", on switchboard 
form in local db, hides the local access application and results in either of the 
following -
    (a) If external db is not yet open, a new instance of access application is created, 
         in which external db is opened and its switchboard form is displayed.
    (b) If external db is already open, it gets un-hidden and its switchboard form is 
In external db, opening of form F_Reports results in loading of all available report 
names (from AllReports collection) in the list box, facilitating print/preview.
In external db, clicking the go-back button (or closing the switchboard form) results 
in hiding of external db and un-hiding of local db.
Any of the following actions in local db ensures closure of external db (if still open) -
    (a) Click command button for closing external db.
    (b) Close switchboard form of local db.
    (c) click command button for closing local db.

References - DAO 3.6

Download Access XP & 2K: uploads/37/


Back to Top
Sponsored Links

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.