How can I create a table in my Access database dynamically in ASP?

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

  1. #1

    Default How can I create a table in my Access database dynamically in ASP?

    How can I create a table in my Access database dynamically using ASP?


    michaaal Guest

  2. Similar Questions and Discussions

    1. Selecting one particular field in the same Access database table?
      Is there a way of selecting one particular field in the same Access database table? eg. database is - ID: 1 ...
    2. Insert table - ASP and access database
      Hi, I am working towards trying to insert data in to two tables from one form. My code won't work so I have simplified everything. I...
    3. Could not access/create a database on a NFS mount / Please help to fix that
      Hello, I'm using INFORMIX-SE Personal Edition Version 7.25.TC3 on Windows 2000 (NTFS). 1.If I run DB-Access, choose "connect to" server :...
    4. How can I dynamically create a MS Access database?
      On my web server, I want my ASP code to check and see if the file called "SECURITY.MDB" exists and if it doesn't then I want it to dynamically...
    5. CREATE TABLE IN ACCESS
      Hi all, Quick question, how do you create a table in MS Access from with an asp script? I will be creating the table name from ...
  3. #2

    Default Re: How can I create a table in my Access database dynamically in ASP?

    set conn = CreateObject("ADODB.Connection")
    conn.open "<connection string>"
    conn.execute("CREATE TABLE foo(splunge INT)")


    Also some examples here
    [url]http://www.aspfaq.com/2029[/url]

    --
    Aaron Bertrand
    SQL Server MVP
    [url]http://www.aspfaq.com/[/url]




    "michaaal" <res0gyio@verizon.net> wrote in message
    news:elj1XQI5DHA.2776@TK2MSFTNGP09.phx.gbl...
    > How can I create a table in my Access database dynamically using ASP?
    >
    >

    Aaron Bertrand [MVP] Guest

  4. #3

    Default Re: How can I create a table in my Access database dynamically in ASP?

    [url]http://www.aspmessageboard.com/forum/databases.asp?M=251953&F=21&P=1[/url]

    Best regards,
    J. Paul Schmidt, Freelance ASP Web Developer
    [url]http://www.Bullschmidt.com[/url]
    ASP Design Tips, ASP Web Database Demo, Free ASP Bar Chart Tool...


    *** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
    Don't just participate in USENET...get rewarded for it!
    Bullschmidt Guest

  5. #4

    Default Re: How can I create a table in my Access database dynamically in ASP?

    what is there in creating a table in MS-ACCESS?
    Bullschmidt <paul@bullschmidt.com-nospam> wrote in message news:<#X$xmbl6DHA.1664@TK2MSFTNGP11.phx.gbl>...
    > [url]http://www.aspmessageboard.com/forum/databases.asp?M=251953&F=21&P=1[/url]
    >
    > Best regards,
    > J. Paul Schmidt, Freelance ASP Web Developer
    > [url]http://www.Bullschmidt.com[/url]
    > ASP Design Tips, ASP Web Database Demo, Free ASP Bar Chart Tool...
    >
    >
    > *** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
    > Don't just participate in USENET...get rewarded for it!
    bharath Guest

  6. #5

    Default Re: How can I create a table in my Access database dynamically in ASP?

    > what is there in creating a table in MS-ACCESS?

    Could you rephrase the question?


    Aaron Bertrand [MVP] 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