Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Access Permission and Scheduled Tasks

Status
Not open for further replies.

ratnek

Programmer
Apr 2, 2002
4
US
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.
 
Access needs the desktop being visible (Anyone being logged on) to open any DB - my own experience on that issue. Don´t you have got one PC in the network that is always logged on? Try to open the database via network on that PC.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top