Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2002
    Posts
    61

    Unanswered: Run SQL Queries from Access

    I created 8 SQL queries that create a new table within a SQL Database and I use this table within Access to create reports. In order to update this table I have to load the Query Analyzer. I was wondering if it was possible to run a these multiple SQL queries while in Access?

    Thanks!!

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    yes

    from the menu bar, Query > SQL Specific > Pass-Through


    rudy
    http://r937.com/

  3. #3
    Join Date
    Oct 2002
    Posts
    61
    Rudy,
    Thanks I guess this is where I would put the SQL Queries?


    Thanks Again!!

  4. #4
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    i would say: try it

    start with a SELECT query as your pass-through query, make sure it can access (no pun intended) the remote database, and then try your update queries

Posting Permissions

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