I have a simple VB6 application that opens an Access 2000 DB and runs two macros.
When someone is logged on, I can set a scheduled task to run the application as anyone with a proper network password and it works fine.
But when no one is logged onto the computer and the scheduled task is set to run under the same person the "permission denied" error is generated if the user does not have local admin rights.
The database has no password protection.
What is denying the ability to open the database?
Please note that there are other reading and writing operations the application does within the same folder as the database and the user has no problem doing these read/write operations.
When someone is logged on, I can set a scheduled task to run the application as anyone with a proper network password and it works fine.
But when no one is logged onto the computer and the scheduled task is set to run under the same person the "permission denied" error is generated if the user does not have local admin rights.
The database has no password protection.
What is denying the ability to open the database?
Please note that there are other reading and writing operations the application does within the same folder as the database and the user has no problem doing these read/write operations.