Results 1 to 6 of 6
  1. #1
    3 Star Lounger MacroAlan's Avatar
    Join Date
    Feb 2003
    Location
    St Louis, Missouri, USA
    Posts
    254
    Thanks
    6
    Thanked 1 Time in 1 Post

    Run Access Update Query from Excel VBA (VBA/Excel/2000/SR-3)

    My Excel modules are updating Access successfully. What I want to do in the next step is to run a query in Access that will synchronize several tables.

    Anybody help with some syntax? I don't know where to start.
    Alan

  2. #2
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Run Access Update Query from Excel VBA (VBA/Excel/2000/SR-3)

    If you mean Access SQL syntax, we'll slide this over to the Access board where the gurus are perhaps too busy to escape to our neck of the woods. <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

  3. #3
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Run Access Update Query from Excel VBA (VBA/Excel/2000/SR-3)

    I think the question probably belongs here in VB/VBA ... at least until further explanation indicates otherwise. <img src=/S/grin.gif border=0 alt=grin width=15 height=15>
    Charlotte

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Run Access Update Query from Excel VBA (VBA/Excel/2000/SR-3)

    Syntax for what, Alan? You said you're updating Access successfully, but to make the thread free-standing can you explain what you are doing and what you need help doing? Are you after automation code, SQL syntax, or something else?
    Charlotte

  5. #5
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Run Access Update Query from Excel VBA (VBA/Excel/2000/SR-3)

    By the way, here's a sample of ADO code that runs several stored queries in an Access database from VBA in a Word template. It's so old I don't really remember all that much about it, but it's deployed to about 40 users, and probably a dozen of them have used it every month for a few years with no reports of problems.

  6. #6
    3 Star Lounger MacroAlan's Avatar
    Join Date
    Feb 2003
    Location
    St Louis, Missouri, USA
    Posts
    254
    Thanks
    6
    Thanked 1 Time in 1 Post

    Re: Run Access Update Query from Excel VBA (VBA/Excel/2000/SR-3)

    Everybody is supposed to understand what I mean even if I leave out half the explanation. <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

    I goofed up big time. Still messing around with learning SQL Server stuff. Turns out I did not wait long enough to synchronize. I thought I was going to have to build an Update Query to sync the local and on-line files.

    Thanks everyone!
    Alan

Posting Permissions

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