Hi, I need to run some Access queries at midnight please help me in regards. I saw some articles related to MACRO but for them I must have to open the Access Database. Is there any thing like SQL Queries can be run from Command Prompt and we can make 1 cmd file to put in Windows schedule

You can use Windows Task Scheduler to open an MDB file. Then use an Autoexec Macro to run the queries you want.