CODEWITHSUNDEEP
ms-accessscheduled-tasks
macieira
macieira

Reputation: 359

Create a Schedule task that run a access file

Im confusing how the Schedule task can run a Microsoft Access module.

I want to have a server with the access Database and forms (accdb file) with it. In this serve there isnt microsoft access installed only the accdb file. The users access the file by remote.

i created a module that send emails, im i wat to know if its possible to create any ST that access the access file without the serve have the Microsoft Access installed.

Best Regards

Upvotes: 1

Views: 374

Answers (1)

HansUp
HansUp

Reputation: 97101

Without Access installed on the machine where the scheduled task runs, you will not be able to run the procedure stored in a VBA module in your ACCDB file.

Adapt your VBA procedure to VBScript and run the VBScript file as a scheduled task.

Upvotes: 1

Related Questions