Creating a Document Flow Manager in Access.

  • Thread starter Thread starter Greg Allen via AccessMonster.com
  • Start date Start date
G

Greg Allen via AccessMonster.com

Hi,

Any ideas on creating a DFM in access. I am trying to create a network folder where xml files are dropped and then automatically picked up and dropped into my access database. I can create a macro to check and import the file I just can't find a way of leaving it running. Is there any script (a loop of sum kind) to leave this permanently running and if so what affect on system resuorces would it have.

Also would it affect trying to run another macro at the same time.

Any help really would be appreciated.

Regards

Greg
 
Hi Greg,

You can use the Timer event on a form to trigger your macro at regular
intervals.

Access (and the other Office applications) aren't designed for
continuous unattended operation. These KB articles explain some of the
issues:

Considerations for Server-Side Automation of Office:
http://support.microsoft.com/?id=257757

Configure Office Applications to Run Under a Specific User Account
http://support.microsoft.com/?id=288367

Hi,

Any ideas on creating a DFM in access. I am trying to create a network
Click to expand...
folder where xml files are dropped and then automatically picked up and
dropped into my access database. I can create a macro to check and
import the file I just can't find a way of leaving it running. Is there
any script (a loop of sum kind) to leave this permanently running and if
so what affect on system resuorces would it have.
 
Back
Top