Post reply

Access jobs

  • September 8, 2008 at 5:05 am

    #382564

    Is it possible to run a macro or VBA script in Access that links to a SQL Server database? I'm thinking of a job that can be scheduled to run once a week.

    I'm not an Access person so I've been researching the web sites without much luck

    :Whistling:

    Madame Artois

  • September 8, 2008 at 5:54 am

    #868351

    This is possible but you will need to supply more information if you need help with this. What are you trying to do?

    Facts are stubborn things, but statistics are more pliable - Mark Twain
    Carolyn
    SQLServerSpecialists[/url]

  • September 8, 2008 at 6:14 am

    #868362

    I was trying to find out if someone was running a macro or similar from Access linking to one of my SQL databases. This was because the transaction log of one database was growing enormously once a week. I've since discovered what was causing the transaction log to grow; it wasn't related to Access.

    However I would like to know if an Access macro can be scheduled to run once a week like a SQL job. The Access user does have connectivity to the SQL database, links to the SQL Server database to copy data which he can then manipulate for his purposes.

    Madame Artois

  • September 8, 2008 at 6:35 am

    #868371

    run sp_who2 and check the column programName. If someone is using Access that will be marked there.

    In 2005+, if you access to login trigger where you can do similar things with a lot more accuracy (since the trigger fires for all connections, and not only when scheduled by a job).

    My guess is that the log was growing a lot because of reindexing job or something similar. It could also have been a weekly massive import, or big report running.

    It would be nice to let us know which one it was for other persons having the same problem.

    All the best.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply