Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Lewes, East Sussex, Sussex, United Kingdom
    Thanked 0 Times in 0 Posts

    Access Automation


    At work, we have a series of 5 read-only databases in A2K which read data from various A97 databases and then display it on flat-panel monitors. The PC's which run the databases are tucked away in a loft and are very inaccessible.

    Sometimes we need to close these databases down for maintenance or to compact them, and we want to do this remotely for the reason given above.

    I have tried using Automation in A2K to do this, but it will only open a copy of the database, and I need a pointer to the currently running version.

    Does anyone have any good ideas as to how to get round this problem - Windows Task Scheduler, PC Anywhere ?



  2. #2

    Re: Access Automation


    One solution to this problem is to have a timer on a hidden Form in the database that you want to close. The timer would run every 5 mins and read a flag file on the network. When you set the flag (say to '1') the application should then close all open forms and quit the application.

    This method is detailed in the Access Power Programming book by F Scott Baker. His solution is more elaborate than what you will require as his uses a message box to ask the users to logout and then commences a countdown.

    Better to run the timer every 15 mins if you can. That means that after a maximun of 15 mins from setting the flag, each of the 5 database would have closed.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts