Ask Experts Questions for FREE Help !
Ask
    fnbros's Avatar
    fnbros Posts: 1, Reputation: 1
    New Member
    		  
    #1

    Apr 7, 2008, 02:59 AM
    Schedule for Access Query
    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
    ScottGem's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man
    		  
    #2

    Apr 8, 2008, 06:08 AM
    You can use Windows Task Scheduler to open an MDB file. Then use an Autoexec Macro to run the queries you want.
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Access Query Design [ 10 Answers ]

Hi all, I am new to the site and would appreciate any help. I have set of data I am having trouble with. I have one table which contains a series of “Assignment IDs”, products and the dates for which those products were matched to those Assignment IDs. The second table is grouped by product...

Crosstab Query in MS Access [ 1 Answers ]

How can I change the my query to crosstab query.. please see the picture.. http://www.l22l.com/l22l-up-1/8a7081adec.jpg I write this code... how can I change to a crosstab query SELECT SeaTable.location, Count(SeaTable.location) AS CountOflocation FROM SSFMainTable INNER JOIN SeaTable...

Update Query in Access [ 1 Answers ]

Hi there! How can I update different records differently in one field based on different criteria? Can I use the update query for that? Do I have to use a macro? Thanks for the help!

View more questions Search