Creating queries in Access (for ASP)

Ask a Question related to ASP Database, Design and Development.

  1. #1

    Default Creating queries in Access (for ASP)

    Hi,

    So far I have been writing ASP and embedding my SQL in the ASP pages. But,
    I've heard advantages of creating queries inside the database program. So
    I'm wondering if someone can give me an example of how to create queries
    inside MS Access and then call them in an ASP page. (or point me to a
    tutorial that does that).

    Thanks.


    Asad Khan Guest

  2. Similar Questions and Discussions

    1. Simultaneous SQL queries to Access
      In evaluating asp and an Access database as a way to store user data from an Authorware training piece, I ran across this article: "For...
    2. SQL queries when Access is open
      My Authorware training piece sends and retrieves data through asp pages that are connected to an Access database. Three asp pages use SQL SELECT,...
    3. Creating variable driven MYSQL queries?
      I've been looking at hand coding my PHP MYSQL queries, and sort of getting the hang of them, but one thing is bothering me. Everyone seems to build...
    4. Creating Queries does not give any result
      I get the following error: Error Type: Microsoft VBScript runtime (0x800A01A8) Object required: '' /myweb4/authorised_user_page.asp, line 70 ...
    5. Translate Access queries to ASP
      Hi, I'm still confused about my queries, I want to do something is ASP that is easily done in Access. I'll post the Access queries below as a...
  3. #2

    Default Re: Creating queries in Access (for ASP)

    Asad Khan wrote:
    > Hi,
    >
    > So far I have been writing ASP and embedding my SQL in the ASP pages.
    > But, I've heard advantages of creating queries inside the database
    > program. So I'm wondering if someone can give me an example of how to
    > create queries inside MS Access and then call them in an ASP page.
    > (or point me to a tutorial that does that).
    >
    > Thanks.
    Here's a couple:
    [url]http://tinyurl.com/qg4o[/url]
    [url]http://tinyurl.com/qg3u[/url]
    [url]http://tinyurl.com/qg47[/url]
    [url]http://tinyurl.com/qg4j[/url]


    Bob Barrows Guest

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139