scheduled task question

J

jaime

Can anyone help me with this?

I'd like to automatically schedule an Access macro to run.
I have most of it figured out...I can get the macro to run
but only after I sign into Access. Is there any way to
program my Access username and password into the bat file
so that this job can run without any intervention from me?

Thanks!
 
R

Ross Presser

Can anyone help me with this?

I'd like to automatically schedule an Access macro to run.
I have most of it figured out...I can get the macro to run
but only after I sign into Access. Is there any way to
program my Access username and password into the bat file
so that this job can run without any intervention from me?

Thanks!
Click to expand...

SET USERNAME=foo
SET PASSWORD=bar
msaccess /user %USER%NAME% /pwd %PASSWORD%
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Why is schedule task not running? 5
Trying to run a MSQuery from Excel as a Scheduled Task 1
No Current Record Error, Scheduled Task 4
Windows 8 (cross-post from w2k forum) Running .bat files minimized from scheduler - in windows 8 (x64) ?? 0
Batch 2
Run Macro If Cell have "x" value 0
scheduled tasks not starting 2
Windows Task Scheduler and Access macros 1

Top