Has anyone experience running Access2000+ data load and form routines with Boston Workstation?
Basically, I am running a script to perform multi-file validation, then upon successful validation, I need to open an Access Form to load files into tables and perform various other access commands to accumulate and consolidate data. I will then run a nested script to archive the files I've loaded into Access. Once a month, I will import this consolidated data (from these Access tables) into my HIS system.
I don't have Visual basic developers or Access developers and am thinking I need to do this through DAO however, if you have worked with interfacing Access forms with your scripts, I would appreciate hearing from you.
Thanks
Pat Thomson
Support St. Joseph's Healthcare Hamilton. Donate today at www.stjoesfoundation.ca
