Scheduled task to open a database and run a macro

[kdbailey]

I have a ".bat" file that I am running as a scheduled task, but it will not find the database if it has spaces in it. This is my file:

C:
CD\Program Files\Microsoft Office\OFFICE11
MSACCESS.EXE S:\shared\Quality\PQG\RT_Warranty_Database_Backup. mdb /x Overnight



But when the database reads "RT Warranty Database.mdb" the execution only looks for "RT.mdb"
How do I get this to go through without having to rename the database?

[JoeM]

Try enclosing your full path and database name in double-quotes (and get rid of the space between your period and file extension), i.e.
"S:\shared\Quality\PQG\RT Warranty Database Backup.mdb"

[kdbailey]

That space between the extention was a typo, I will give that a try in a minute.

[kdbailey]

Worked, thanks!