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 [allowsmilie] => 1 [showsignature] => 0 [ipaddress] => [iconid] => 0 [visible] => 1 [attach] => 0 [infraction] => 0 [reportthreadid] => 0 [isusenetpost] => 1 [msgid] => [ref] => [htmlstate] => on_nl2br [postusername] => paross1 [ip] => webforumsuser@m [isdeleted] => 0 [usergroupid] => [membergroupids] => [displaygroupid] => [password] => [passworddate] => [email] => [styleid] => [parentemail] => [homepage] => [icq] => [aim] => [yahoo] => [msn] => [skype] => [showvbcode] => [showbirthday] => [usertitle] => [customtitle] => [joindate] => [daysprune] => [lastvisit] => [lastactivity] => [lastpost] => [lastpostid] => [posts] => [reputation] => [reputationlevelid] => [timezoneoffset] => [pmpopup] => [avatarid] => [avatarrevision] => [profilepicrevision] => [sigpicrevision] => [options] => [akvbghsfs_optionsfield] => [birthday] => [birthday_search] => [maxposts] => [startofweek] => [referrerid] => [languageid] => [emailstamp] => [threadedmode] => [autosubscribe] => [pmtotal] => [pmunread] => [salt] => [ipoints] => [infractions] => [warnings] => [infractiongroupids] => [infractiongroupid] => [adminoptions] => [profilevisits] => [friendcount] => [friendreqcount] => [vmunreadcount] => [vmmoderatedcount] => [socgroupinvitecount] => [socgroupreqcount] => [pcunreadcount] => [pcmoderatedcount] => [gmmoderatedcount] => [assetposthash] => [fbuserid] => [fbjoindate] => [fbname] => [logintype] => [fbaccesstoken] => [newrepcount] => [vbseo_likes_in] => [vbseo_likes_out] => [vbseo_likes_unread] => [temp] => [field1] => [field2] => [field3] => [field4] => [field5] => [subfolders] => [pmfolders] => [buddylist] => [ignorelist] => [signature] => [searchprefs] => [rank] => [icontitle] => [iconpath] => [avatarpath] => [hascustomavatar] => 0 [avatardateline] => [avwidth] => [avheight] => [edit_userid] => [edit_username] => [edit_dateline] => [edit_reason] => [hashistory] => [pagetext_html] => [hasimages] => [signatureparsed] => [sighasimages] => [sigpic] => [sigpicdateline] => [sigpicwidth] => [sigpicheight] => [postcount] => 2 [islastshown] => 1 [isfirstshown] => [attachments] => [allattachments] => ) --> list tables from Access 2000 - Coldfusion Database Access

list tables from Access 2000 - Coldfusion Database Access

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...

  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. #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

Similar Threads

  1. Access 2002 PDFWriter VBA Code w/WinXP does not work like Access 2000
    By Tony_VBACoder in forum Adobe Acrobat Windows
    Replies: 3
    Last Post: April 30th, 07:44 PM
  2. Access 2000 or SQL Server 2000
    By Denis in forum ASP Database
    Replies: 1
    Last Post: January 25th, 03:38 PM
  3. List Access database tables
    By Kevin Ingram in forum ASP Database
    Replies: 7
    Last Post: January 9th, 04:09 AM
  4. Replies: 1
    Last Post: October 5th, 06:14 AM
  5. Adding Tables to a form in Access 2000
    By Bill McAdoo in forum Microsoft Access
    Replies: 1
    Last Post: July 13th, 07:09 AM

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
  •