Results 1 to 11 of 11
  1. #1
    Join Date
    Mar 2004
    Posts
    6

    Unanswered: Automated query/make-table refresh

    Is there a way to make Access run queries that make tables at a specified time everday?

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713

    Re: Automated query/make-table refresh

    Originally posted by Imola
    Is there a way to make Access run queries that make tables at a specified time everday?
    Sure ... Use either a timer or you could use the scheduler to activet access and run a process to do that ...

  3. #3
    Join Date
    Mar 2004
    Posts
    6
    Can a timer operate when no one opens Access?

    This Access file runs multiple queries that create tables. Multiple Excel files read from the created tables.

    I need to have new tables everyday at 8:30AM and want to automate this without touching the Access file.

    Possible?

  4. #4
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Originally posted by Imola
    Can a timer operate when no one opens Access?

    This Access file runs multiple queries that create tables. Multiple Excel files read from the created tables.

    I need to have new tables everyday at 8:30AM and want to automate this without touching the Access file.

    Possible?
    No ...

    Use the Windows Scheduler then ...

  5. #5
    Join Date
    Mar 2004
    Posts
    6
    Originally posted by M Owen
    No ...

    Use the Windows Scheduler then ...
    Meaning I need to be logged on.

    Can Windows Scheduler work while Windows 2000 logs me off after a certain time?

  6. #6
    Join Date
    Mar 2004
    Posts
    6
    Alright, I got Windows scheduler up to activate the Access file, but now I need set the file to refresh upon opening.

  7. #7
    Join Date
    Sep 2001
    Location
    Chicago, Illinois, USA
    Posts
    601
    What do you mean by "the file to refresh upon opening."

    Do you mean that you want the .MDB to autoexecute and complete some task (run the make table queries)?

  8. #8
    Join Date
    Mar 2004
    Posts
    6
    Yes

    autoexecute to delete old tables

    and run queries to make new tables

    BTW, FYI, administrators locked up my ability to operate Windows Scheduler.

  9. #9
    Join Date
    Sep 2001
    Location
    Chicago, Illinois, USA
    Posts
    601
    I'm not sure what you are going to be able to accomplish if you have to be logged off your computer and you can't use Windows Scheduler.

    Before you go further, you are going to need to arrange something to allow a scheduled process to run.

  10. #10
    Join Date
    Mar 2004
    Posts
    6
    definitely, i don't think Access has true autoexecute ability

    otherwise, with windows scheduler, i only need a start up macro after windows scheduler

  11. #11
    Join Date
    Sep 2001
    Location
    Chicago, Illinois, USA
    Posts
    601
    "i don't think Access has true autoexecute ability"

    Access has the same ability as VB, C++, FORTRAN, etc., etc.

    No program, be it VB, C++, FORTRAN, etc., etc. runs unless it it told to run.

    So, regardless of what you are writing this in, you need to provide the service which will execute the program.

    It's either your finger doing a double-click, or a scheduler program.

    But YOU need to provide that. It's not Access' falt.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •