Professional Web Applications Themes

How to rename Access tables and field names? - ASP Database

Jet SQL doesn't support any kind of rename statements directly. I figured this can probably be handled through ASP but I'm not sure how to go about it. Any help would be appreciated...thanks....

  1. #1

    Default How to rename Access tables and field names?

    Jet SQL doesn't support any kind of rename statements
    directly. I figured this can probably be handled through
    ASP but I'm not sure how to go about it. Any help would
    be appreciated...thanks.
    Marshal Guest

  2. #2

    Default Re: How to rename Access tables and field names?

    Marshal wrote:
    > Jet SQL doesn't support any kind of rename statements
    > directly. I figured this can probably be handled through
    > ASP but I'm not sure how to go about it. Any help would
    > be appreciated...thanks.
    Nope. You have to create new objects with the names you want and delete the
    old ones.

    Bob Barrows


    Bob Barrows Guest

  3. #3

    Default Re: How to rename Access tables and field names?

    I found a way to do it if you want to check it out.

    [url]http://www.4guysfromrolla.com/webtech/tips/t030802-1.shtml[/url]
    >-----Original Message-----
    >Marshal wrote:
    >> Jet SQL doesn't support any kind of rename statements
    >> directly. I figured this can probably be handled
    through
    >> ASP but I'm not sure how to go about it. Any help
    would
    >> be appreciated...thanks.
    >
    >Nope. You have to create new objects with the names you
    want and delete the
    >old ones.
    >
    >Bob Barrows
    >
    >
    >.
    >
    Marshal Guest

  4. #4

    Default Re: How to rename Access tables and field names?

    Sorry - I did not realize those properties were read/write. When I first
    read about ADOX, they weren't (IIRC). This must have changes when the Jet
    4.0 engine was released.

    Bob Barrows

    Marshal wrote:
    > I found a way to do it if you want to check it out.
    >
    > [url]http://www.4guysfromrolla.com/webtech/tips/t030802-1.shtml[/url]
    >
    >> -----Original Message-----
    >> Marshal wrote:
    >>> Jet SQL doesn't support any kind of rename statements
    >>> directly. I figured this can probably be handled through
    >>> ASP but I'm not sure how to go about it. Any help would
    >>> be appreciated...thanks.
    >>
    >> Nope. You have to create new objects with the names you want and
    >> delete the old ones.
    >>
    >> Bob Barrows
    >>
    >>
    >> .

    Bob Barrows Guest

Similar Threads

  1. Get list of all Field Names in ORACLE DB
    By SteveThePilot in forum Coldfusion Database Access
    Replies: 7
    Last Post: August 28th, 05:28 AM
  2. Accessing duplicate field names from different tables
    By cakesy in forum Coldfusion Database Access
    Replies: 7
    Last Post: March 10th, 09:45 AM
  3. CFQUERYPARAM with tables names
    By Don Vaillancourt in forum Coldfusion Database Access
    Replies: 5
    Last Post: October 6th, 09:00 PM
  4. querying field / column names in Access table
    By Brian Gallutia in forum Coldfusion - Getting Started
    Replies: 3
    Last Post: April 28th, 07:05 PM
  5. Get database field names from table...
    By bweno in forum Coldfusion Database Access
    Replies: 2
    Last Post: March 11th, 06:43 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not 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