list tables from Access 2000

Ask a Question related to Coldfusion Database Access, Design and Development.

  1. #1

    Default Re: list tables from Access 2000

    What is the output variable?
    Who do you give read permissions to?

    Why would this need more permissons that a script that actually makes tables?
    I think that would be done using the system account.

    Thanks

    Kieran Mullen

    manylists Guest

  2. Similar Questions and Discussions

    1. Access 2000 or SQL Server 2000
      Hi I am planning to design a database (destined for the web) that will have between 20000 and 45000 records in it and will receive a lot of reads...
    2. List Access database tables
      I am using ASP and a MS-Access database. Can read and write to tables fine, but now I have a need to list all the tables in a given database. I...
    3. how I can get a list of tables with asp and access 2000
      Hi guys, I have dsn connection to my access 2000 database and I am using clasic asp. So I wanna get a list of tables so, could you gelp me...
    4. Linking Informix tables to SQL Server 2000
      I am having difficulty creating a linked server (Informix) in Microsoft SQL Server 2000. I have successfully installed the Informix OLEDB driver;...
    5. Adding Tables to a form in Access 2000
      I created several tables and forms for the individual tables. I also created one additional form that would include data from all of the tables. ...
  3. #2

    Default Re: list tables from Access 2000

    Well, normally these "system objects" aren't "visible", nor are there any
    permissions enabled on them. First thing you would do would be to select
    Tools-->Options-->View and enable Show System Objects in Access. Then you could
    select Tools-->Security-->User and Group permissions, and enable Read Data on
    MySysObjects.

    So you see, you would "need more permissons than a script that actually makes
    tables".

    Also, Not Like "MSys*" should be changed to Not Like 'MSys*' (single quotes)
    in order to run from within a CFQUERY in CF.

    Phil

    paross1 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