* * * Currently this backend database opens to a simple form. Click on "update data" and a procedure run that takes an external text file and replaces the current contents of one Access table with the contents of this text file. It copies the table being updated prior to running this procedure.
* * * User-level security is implemented, so I get to the database via a shortcut that references the *.mdw file for this database. Then I manually type in the username and password for the database.
* * * I used to be able to run this in the morning when I came in, but now my users are actually using (gasp!) their database more and I can't get exclusive access to it during normal working hours.
* * * How can I get this procedure to run automatically from the Task Scheduler?
* * * Tx for taking time to read this. Any help gratefully received and STARRED.
JSouth
* * * User-level security is implemented, so I get to the database via a shortcut that references the *.mdw file for this database. Then I manually type in the username and password for the database.
* * * I used to be able to run this in the morning when I came in, but now my users are actually using (gasp!) their database more and I can't get exclusive access to it during normal working hours.
* * * How can I get this procedure to run automatically from the Task Scheduler?
* * * Tx for taking time to read this. Any help gratefully received and STARRED.
JSouth